topic Re: Summary by level in a dataset in SAS Programming

Summary by level in a dataset

jonatan_velarde — Wed, 20 Jan 2016 14:17:28 GMT

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

Re: Summary by level in a dataset

RW9 — Wed, 20 Jan 2016 14:33:29 GMT

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;

Re: Summary by level in a dataset

Astounding — Wed, 20 Jan 2016 14:51:50 GMT

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;