topic Re: Why I cannot change axis tick values in proc sgplot? in Graphics Programming

Why I cannot change axis tick values in proc sgplot?

henryjing — Thu, 01 Dec 2016 03:08:53 GMT

The variable EDUCATION has values 1 2 3 4 5 6, which stand for graduate_school, university, high_school, etc.

I am trying to plot a standardized segment bar plot as following (picture 1), and I'm also trying to change the tick value to graduate_school, etc, which are what these value really mean.

%let education_label = "graduate_school" "university" "high_school"
"others" "unknown1" "unknown2";
proc sgplot data=Freq_Education_default;
vbar EDUCATION / response = percent group=default
groupdisplay=stack;
xaxis discreteorder=data valuesdisplay =(&education_label);
yaxis grid values=(0 to 100 by 10) label="Percentage of total in group";
run;

However, if I change "valuesdisplay" to "values", the plot changes to picture 2, neither of two pictures is what I am aiming for.

Re: Why I cannot change axis tick values in proc sgplot?

Reeza — Thu, 01 Dec 2016 03:24:47 GMT

Use a format, not a macro. If a level was missing the labels wouldn't align automatically, whereas they would with a format.

proc format;
value educ_fmt
1="graduate_school"
2="university"
3="high_school"
..
9 = "unknown2";
run;

Then apply the format within your proc.

proc sgplot data=Freq_Education_default;
vbar EDUCATION / response = percent group=default
groupdisplay=stack;

format education educ_fmt.;

xaxis discreteorder=data;
yaxis grid values=(0 to 100 by 10) label="Percentage of total in group";
run;

Re: Why I cannot change axis tick values in proc sgplot?

henryjing — Thu, 01 Dec 2016 03:41:32 GMT

Reeza

I really appreciate your help.

I eventually get what I want.

Again, thanks so much.

Henry