proc sql find count and percent

Ayooo1 — Tue, 10 Jan 2023 14:36:35 GMT

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:

Re: proc sql find count and percent

PaigeMiller — Tue, 10 Jan 2023 14:47:10 GMT

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;

topic Re: proc sql find count and percent in SAS Programming

proc sql find count and percent

Re: proc sql find count and percent