We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
Level I

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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 5 REPLIES 5 Highlighted Level VI 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. Highlighted Level I 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. Highlighted Level VI 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 ) ) Highlighted 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
Highlighted
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