proc freq formating question

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 84
Accepted Solution

proc freq formating question

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;

freq.PNG


Accepted Solutions
Solution
‎04-22-2014 05:58 PM
Super User
Posts: 19,789

Re: proc freq formating question

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;

View solution in original post


All Replies
Solution
‎04-22-2014 05:58 PM
Super User
Posts: 19,789

Re: proc freq formating question

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;

Frequent Contributor
Posts: 84

Re: proc freq formating question

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

nope.PNG

Frequent Contributor
Posts: 84

Re: proc freq formating question

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 254 views
  • 1 like
  • 2 in conversation