cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
eri
eri
Level I

JSL to export Process Screening Detail Table

New JMP user here -- I would like to use JSL to save the output of a Process Screening analysis -- in particular, the Details Table. If I run the Process Screening analysis, a summary report pops up, and I've figured out how to save that. But from that report, I can click the red triangle and then "Save Details Table" to get much more granular information. I would like to save that table to a csv as well, but the "Copy session Script" option doesn't seem to work -- it gives the hardcoded data, not applicable to a new data file.

 

I would like something like this: 

dt = Open("C:\Program Files\SAS\JMP\16\Samples\Data\Consumer Prices.jmp", window bounds(-1781, -373, -974, 135));

scr = dt << Process Screening(
	Process Variables( :Price ),
	Grouping( :Series ),
	Control Chart Type( "Indiv and MR" ),
	Time( :Date )
);

// Save the process screening summary as .csv
dt2 = Report(scr)[TableBox(2)] << makeDataTable;
dt2 << save( "C:\Users\myname\Downloads\test.txt" )

// <Script to also save the process screening details table as a csv>

Thanks for any help!

1 REPLY 1
jthi
Super User

Re: JSL to export Process Screening Detail Table

Take a look at Scripting Index (found from JMP Help menu) and search for Save Details Table:

jthi_0-1622836851703.png

You can get reference of the Details table by changing the last line to:

dt_details = obj << Save Details Table;

and you should be able to save by using that reference

-Jarmo

Recommended Articles