PROC FREQ

[robertrao]

Hi ,

I have the following;

ID DESCRIPTION

01   Fever

02  Headache

03 sprain

01 Fever

01 Fever

I was using and missing the description in the output.

can someone help me with this

Proc freq data=have;

tables ID/out=freqs;

run;

I get

ID Count

01  3

02  1

03  1

I want  counts by ID and Description

ID DESCRIP COUNT

01 fever 3

02 Headache 1

03 sprain 1

Thanks

[mohamed_zaki · Accepted solution]

proc sql;

select  *,sum(1) as COUNT

from have

group by ID ,DESCRIPTION;

run;

[stat_sas]

proc freq data=have;

table id*DESCRIPTION/list norow nocol nopercent nocum;

run;

[Ksharp]

Proc freq data=have;

tables ID*DESCRIPTION/out=freqs   norow nocol nopercent nocum;

run;