proc gchart, creating age distributions of employment

[jdub]

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?

[DF]

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;