General SAS Programming

[jonatan_velarde]

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

[RW9 · Accepted solution]

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;

[RW9 · Accepted solution]

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;

[Astounding]

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;