Summary by level in a dataset

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 103
Accepted Solution

Summary by level in a dataset

Good morning SAS friends:

 

i hace this data set:

 

data have:

input ANIMAL    CG_GROW;

cards;
1    1
2    1
3    1
4    1
5    2
6    2
7    3
8    4
9    4
10    4
;

 

i need to obtain a summary info in the output describing the levels of CG_GROW variable and the number of the ocorrences like:

 

variable                  level          n

CG_GROW          1                4

CG_GROW          2                2

CG_GROW          3                1

CG_GROW          4                4

 

 

Thank you for your help


Accepted Solutions
Solution
‎01-20-2016 10:43 AM
Super User
Super User
Posts: 7,720

Re: Summary by level in a dataset

Hi,

 

Not tested yet as my SAS is working on something, but this should be near.

 

proc sql;
  create table WANT as
  select  "CG_GROW" as VARIABLE,
           CG_GROW as LEVEL,
           count(distinct ANIMAL) as N
  from     HAVE
  group by CG_GROW;
quit;

View solution in original post


All Replies
Solution
‎01-20-2016 10:43 AM
Super User
Super User
Posts: 7,720

Re: Summary by level in a dataset

Hi,

 

Not tested yet as my SAS is working on something, but this should be near.

 

proc sql;
  create table WANT as
  select  "CG_GROW" as VARIABLE,
           CG_GROW as LEVEL,
           count(distinct ANIMAL) as N
  from     HAVE
  group by CG_GROW;
quit;
Super User
Posts: 5,363

Re: Summary by level in a dataset

SAS has a very simple tool to create this type of report.  This should become part of your repertoire:

 

proc freq data=have;

tables cg_grow;

run;

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 308 views
  • 1 like
  • 3 in conversation