Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Manipulating data exclusively on subset data

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 24, 2019 9:25 AM
(1237 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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.

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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?

Was the table created using a JSL script or interactively?

Jim

Article Labels

There are no labels assigned to this post.