topic Re: proc freq formating question in SAS Programming

proc freq formating question

robm — Tue, 22 Apr 2014 21:52:26 GMT

Hi how would I format the below as a proc freq statement I did it in pure sql

create table a.&ir._report as

select

ageStrata,

gleasonStrata,

count(ageStrata) as thecount,

(select count(ageStrata) from a.&ir._cases_temp) as thetotal,

count(ageStrata)/(select count(ageStrata) from a.&ir._cases_temp) * 100 as pct

from a.&ir._cases_temp

group by ageStrata,gleasonStrata

order by ageStrata,gleasonStrata;

Reeza — Tue, 22 Apr 2014 21:58:00 GMT

I don't know of a way to get the total in but the rest is generated via:

proc freq data=have;

table agestrata*gleasonStrata/nocol norow list nocum;

run;

robm — Wed, 23 Apr 2014 13:51:06 GMT

that doesn't tally up the occurences of say 35-49 where gleason score =7

robm — Wed, 23 Apr 2014 14:21:32 GMT

aaaghhh I am a dummy I was feeding the wrong data you had answered my question