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:
... View more