topic Re: Reference to the Output Table Name in Discussions

How to name a table via JSL and reference it later in the script?

akash_nigam_gma — Mon, 18 Sep 2017 18:50:19 GMT

Hi I am trying to select a small subset of data from a big datatable and create a temporary table out of it. The overall objective is to sumarize the subset data. The script below is creating the subset data table "Name" but it is not returning the reference to it for me to process the new table. In the script below it is summarize the data of Test data table but not the Name data table.

Please help me with it.

dt=Open("Test.jmp");
Z= NRow();
 
k=dt<< Get Rows Where(:Para == "THK" );
pt = dt << Subset(
Rows(k),
Output Table Name("Name"),
);
 
// I want to summarize the data from this subset  data table
Close (dt, No Save);
 
 
pt = Current Data Table ();
 
Summarize(
  a=by(:Para, Route),
  //b= by(:Route),
  c= count,
  meanHT = mean(SITE_VALUE),
  stdevHT = stddev(SITE_VALUE)
);
 
show (a,c);

Re: Reference to the Output Table Name

ian_jmp — Mon, 18 Sep 2017 18:51:49 GMT

Perhaps the JSL equivalent of 'Tables > Summary' is better in this case?

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
rows2get = dt << getRowsWhere(:sex == "F");
dtSub = dt << Subset(Rows(rows2get), Output Table("Females"));
dtSummary = dtSub << Summary(Mean(:Weight), Group(:age));

Re: Reference to the Output Table Name

akash_nigam_gma — Wed, 16 Dec 2015 16:05:57 GMT

Thanks. It seems to solve my original problem. .

Infact my original script also seems to work just does not allow me easy handling of datatable object. Like in the present case (using your script), I am not able to save the Subset Table. Any suggestions?? Thanks in advance

Close (dtSub, Save);

throws an error.....

I/O problem. Unable to open in ReadWrite mode.

The system cannot find the file specified.

Save changes to the JMP Data Table Female?

Re: Reference to the Output Table Name

ian_jmp — Mon, 18 Sep 2017 18:52:22 GMT

If you use the 'Save' option of 'Close()', you need to tell JMP where to put the file:

NamesDefaultToHere(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
Wait(3);
Close(dt, Save("$DESKTOP/"||(dt << getName)));

Re: Reference to the Output Table Name

txnelson — Mon, 18 Sep 2017 18:51:26 GMT

I might be missing something, but from the original question, the issue stated seemed to be the need to be able to reference the subsetted data table for the summarize function. In JMP 12, there is an additional argument available to the summarize function. You can add the data table as the first argument. So all you would need to do is to change the summarize statement to:

Summarize(pt,
  a=by(:Para, Route),
  //b= by(:Route),
  c= count,
  meanHT = mean(SITE_VALUE),
  stdevHT = stddev(SITE_VALUE)
);

Another observation is that you were using a statement of:

pt = current data table();

What I believe you really wanted to do is to set the current data table to pk, by using:

current data table(pk);

Or am I completely misdirected?

Re: Reference to the Output Table Name

Ressel — Wed, 21 Apr 2021 13:53:11 GMT

What's the difference between

pt = current data table();

and

current data table(pk);

Re: Reference to the Output Table Name

Ryan_Gilmore — Wed, 21 Apr 2021 14:00:13 GMT

pt = current data table();

will get the current data table

current data table(pk);

will set the current data table

Re: Reference to the Output Table Name

Mark_Bailey — Wed, 21 Apr 2021 14:03:11 GMT

The first is a question and the second is a statement.

It is often efficient when working with a data table to obtain a reference to it and then re-use it to send messages. The first usage is calling the function to obtain that reference and storing it in a variable for future reference.

The current data table is a convenience in that most action in JMP defaults to that table if one is not explicitly specified. The second usage assigns a table reference to make it the current data table. Imagine that you have several tables open and want to switch one table to be current.

This provision in JSL is a matter of style. It also depends on the use case if one style is more advantageous than one style.