How can I find count and percent using proc sql? EXDSTXT= treatment. The result table shows percent but not by each separate treatment
data:
proc sql noprint;
create table M_S as
select a.SUBJID,b.EXDSTXT,a.SEX,
case when SEX= 'M' then 'Male'
when SEX= 'F' then 'Female'
else ''
end as sexcatvar,
case when b.EXDSTXT='7 ug/kg/day' then 1
when b.EXDSTXT='9 ug/kg/day' then 2
when b.EXDSTXT='12 ug/kg/day' then 3
when b.EXDSTXT='Total' then 4
else .
end as EXDSN
from Sasfile.Dm as a
inner join EX as b
on a.SUBJID=b.SUBJID
;
quit;
proc sql noprint;
create table FREQST as
select sexcatvar,EXDSN,EXDSTXT,count(sexcatvar) as COUNT,calculated COUNT/ (select count(*) from M_S) as pct format=percent8.2
from M_S
group by sexcatvar,EXDSN,EXDSTXT
order by EXDSTXT;
quit;
result:
That's a lot of work to do this in SQL, all you need to do is the join in PROC SQL and then PROC FREQ computes the statistics much easier
proc freq data=have;
table sex*exdstxt/list;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.