01-20-2016 09:17 AM
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
01-20-2016 09:33 AM
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;
01-20-2016 09:33 AM
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;
01-20-2016 09:51 AM
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;
Need further help from the community? Please ask a new question.