nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Manipulating data exclusively on subset data

aaronjiang

I have a data table that i performed subset on to extract the data I need. Now I want to do analysis on that subset data exclusively, but it is under the same name as the original data table. How can I rename it or separate it out completely from the original data so that I can go on with my data analysis?

Accepted answers

txnelson

Here is a simple example showing how to use pointers to the data table to uniquely reference the tables.

dt = Open( "$SAMPLE_DATA\big class.jmp" );

dt << select where( :sex == "F" );

dt2 = dt << subset( selected rows( 1 ), selected columns( 0 ) );

dt2 << Bivariate( Y( :weight ), X( :height ) );

All comments

MathStatChem

It sounds like you are using a linked subset table.

You have a couple of options.

a) save the subset table to a new JMP file, close the original file, close this file and re-open it and you can work on it independently.

b) when you do a subset, uncheck the box "Link to Original Data Table" in the dialog.

aaronjiang

Thanks! What I am really doing is writing a script that can generate result
directly. I more mean how to separate table of subset from original table,
because right now after i did subset, all data analysis i did on table is
done to all data in original table, not in the subset table.

txnelson

How was your subset created that it ended up having the same name as a previous data table?
Was the table created using a JSL script or interactively?

MathStatChem

You need to explicity state in the script that you don't want the subset to be linked, maybe?

Does your script have the "Linked" option?

Subset(
	Linked, /* do you have this in your script? */
	Suppress formula evaluation( 0 ),
	Selected Rows( 0 ),
	Rows( [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11] ),
	Selected columns only( 0 )
)

txnelson

Here is a simple example showing how to use pointers to the data table to uniquely reference the tables.

dt = Open( "$SAMPLE_DATA\big class.jmp" );

dt << select where( :sex == "F" );

dt2 = dt << subset( selected rows( 1 ), selected columns( 0 ) );

dt2 << Bivariate( Y( :weight ), X( :height ) );