6187_en-US

liliconcom

Creating a summary data table<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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 ?

Re: Creating a summary data table

The following should give you what you are looking for:

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