proc sql find count and percent

[Ayooo1]

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:

[PaigeMiller]

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;