Subscribe Bookmark RSS Feed

Creating a summary data table

connect01

Staff

Joined:

Oct 23, 2012

Hi all -- I'm seeking help in making a summary data table. I currently have an individual-level dataset that I need to convert into a neighborhood-level dataset. The data look something like this:

resp.ID           nh.ID         RUCA

1                    1                   1

2                    1                   1

3                    2                    1.1

4                    2                    1.1

5                    2                    1.1

6                    3                    1.2

7                    4                    2.1

and I need it to look like this:

nh.ID          RUCA

1               1

2               1.1

3               1.2

4                2.1

I know how to create the summary dataset using SAS. See below:

proc sort data = old nodupkey out=new;

by RUCA;

run;

My question is how to create such a summary data table in JMP ?

1 REPLY
peterj

Community Trekker

Joined:

Jun 23, 2011

The following should give you what you are looking for:

Data Table( "YourDataTable" ) << Summary( Group( :nh.ID, :RUCA ) )