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
proc sql;
select *,sum(1) as COUNT
from have
group by ID ,DESCRIPTION;
run;
proc sql;
select *,sum(1) as COUNT
from have
group by ID ,DESCRIPTION;
run;
proc freq data=have;
table id*DESCRIPTION/list norow nocol nopercent nocum;
run;
Proc freq data=have;
tables ID*DESCRIPTION/out=freqs norow nocol nopercent nocum;
run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.