proc gchart, creating age distributions of employment

jdub — Wed, 06 Jul 2011 15:58:15 GMT

Hi,

I have a variable (agegrp) that is an age interval identifier. Values of agegrp would look something like 14-18, 19-21, etc. My second variable is a count of employment (emp) that corresponds to agegrp identifiers. I am trying to create a histogram that is an age distribution of employment. I'd like to graph an age distribution with each series the share of total employment x agegrp. On the y-axis would be percent of total employment and the agegrp identifiers on the x-axis. The code I have so far is:

proc gchart data=manu_agedist(where=(time="1995:1"));

vbar agegrp / dsicrete type=percent

sumvar=emp sum;

run;

This code yields counts of employment on the y-axis and agegrps on the x-axis. Does anyone have advice on how to fix my code so I can graph an age distribution with each series the share of total employment x agegrp?

Re: proc gchart, creating age distributions of employment

DF — Thu, 07 Jul 2011 13:22:22 GMT

Without seeing your source data I've made some assumptions about what it looks like, but the below should do what you need:

data manu_agedist;

format agegrp $10.;

format emp 8.;

infile datalines dsd;

input agegrp $ emp;

datalines;

18-25,500

26-29,250

30-36,333

37-44,123

45-54,999

55-64,40

65+,5

;

run;

proc gchart data=manu_agedist;

vbar agegrp / discrete type=percent freq=emp;

run;

proc tabulate data=manu_agedist;

class agegrp;

var emp;

table agegrp, colpctsum*emp;

run;

topic Re: proc gchart, creating age distributions of employment in SAS Procedures

proc gchart, creating age distributions of employment

Re: proc gchart, creating age distributions of employment