Choose Language Hide Translation Bar
Highlighted
aaronjiang
Occasional Contributor

Manipulating data exclusively on subset data

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?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Manipulating data exclusively on subset data

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 ) );
Jim

View solution in original post

0 Kudos
5 REPLIES 5
MathStatChem
Community Trekker

Re: Manipulating data exclusively on subset data

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.  

0 Kudos
aaronjiang
Occasional Contributor

Re: Manipulating data exclusively on subset data

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.
0 Kudos
MathStatChem
Community Trekker

Re: Manipulating data exclusively on subset data

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 )
)

 

0 Kudos
txnelson
Super User

Re: Manipulating data exclusively on subset data

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 ) );
Jim

View solution in original post

0 Kudos
txnelson
Super User

Re: Manipulating data exclusively on subset data

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?
Jim
0 Kudos