cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
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