topic Re: PROC FREQ in SAS Procedures

PROC FREQ

robertrao — Tue, 21 Oct 2014 13:43:57 GMT

Hi ,

I have the following;

ID DESCRIPTION

01 Fever

02 Headache

03 sprain

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 — Tue, 21 Oct 2014 13:56:20 GMT

proc sql;

select *,sum(1) as COUNT

from have

group by ID ,DESCRIPTION;

run;

stat_sas — Tue, 21 Oct 2014 14:02:30 GMT

proc freq data=have;

table id*DESCRIPTION/list norow nocol nopercent nocum;

run;

Ksharp — Tue, 21 Oct 2014 14:27:13 GMT

Proc freq data=have;

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

run;