topic Grouping by "age" using formats, then summarize in SAS Programming

Grouping by "age" using formats, then summarize

rvsidhu035 — Wed, 28 Mar 2018 13:00:54 GMT

Re: agegrp

Reeza — Tue, 27 Mar 2018 18:41:39 GMT

What is your question?

What have you tried so far?

@rvsidhu035 wrote:

Re: agegrp

Reeza — Tue, 27 Mar 2018 18:43:34 GMT

Here's an example with BMI instead;

https://gist.github.com/statgeek/227565537f3dffcd8627f1fe2eff844f

Pretty much the same idea.

Or I believe there's an example here as well, same BMI, but a step by step walk through

http://video.sas.com/detail/videos/sas-analytics-u/video/4573016759001/performing-conditional-logic-in-sas?autoStart=true

Re: agegrp

rvsidhu035 — Tue, 27 Mar 2018 18:54:52 GMT

from sashelp.class data set develop above table

Re: agegrp

Reeza — Tue, 27 Mar 2018 18:57:22 GMT

What have you tried so far? I don't really feel like doing your homework but I'm happy to help while you're doing it.

Re: agegrp

rvsidhu035 — Tue, 27 Mar 2018 19:01:01 GMT

proc sql;
create table wantk as select 
case when age<11 then '<11' else
	case when age in (11,12) then '11-12' else
		case when age in (13,14) then '13-14' else
			case when age in (15,16) then '15-16' else
				case when age>16 then '>16' else ' ' end
			 end end end end as agegrp,
	count(CALCULATED ageGRP) as count
	from sashelp.class group by ageGRP;quit;
data dummy;
input agegrp $ @@;
cards;
<11 11-12 13-14 15-16 >16
;
run;

proc sql;
create table want3 as select dummy.*,wantk.count from dummy as x  left join wantk as y on 
x.agegrp eq y.agegrp;quit;
proc sql;
create table anser as select 
case when count eq . then 0 else count end as count,agegrp
from want3 order by agegrp desc;

Re: agegrp

Reeza — Tue, 27 Mar 2018 19:07:21 GMT

Besides the order that looks correct. Is there something else you're looking for?

The answer to your third question is the PRELOADFMT in PROC TABULATE with the MISSING option specified. That would actually do all three at once.

Your current code is SQL, so this would be a very different approach but would take advantage of the automatic SAS processing.

Re: agegrp

Reeza — Tue, 27 Mar 2018 19:16:44 GMT

proc format;
value agegroup_fmt
low - 10 = '<11'
11, 12 = '11-12'
13-14 = '13-14'
15-16 = '15-16'
17-high = '>16'
;
run;

proc tabulate data=sashelp.class out=want ;
class age / preloadfmt  exclusive;
format age agegroup_fmt.;
table age / printmiss misstext='0';
run;

Re: agegrp

ChrisNZ — Wed, 28 Mar 2018 02:54:14 GMT

You are been entered in the contest for the least useful thread title of the year. 🙂

Congratulations!

Re: agegrp

ChrisHemedinger — Wed, 28 Mar 2018 13:01:53 GMT

I fixed the title -- though the question looks like a homework assignment...