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?
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.