Data visualization with SAS programming

SAS - stacked bar graph

Accepted Solution Solved
Reply
Highlighted
New Contributor
Posts: 2
Accepted Solution

SAS - stacked bar graph

Hi community members,

 

I was trying to make a stacked bar graph but I am not sure why one of the categories for two variables reveresed their place. Please see the picture attached herewith. my code to produce the chart is:

 

 

 

ods graphics on;
PROC SGPLOT DATA = stress;
VBAR variable / RESPONSE = percent GROUP = endorsed STAT = SUM SEGLABEL CATEGORYORDER = RESPDESC;
YAXIS GRID LABEL = "Percentage";
RUN;
ods graphics off;

 

Thanks,

Pooja


Accepted Solutions
Solution
3 weeks ago
SAS Super FREQ
Posts: 925

Re: SAS - stacked bar graph

I have a hunch about why this happened, but I cannot verify that without your data. However, I think I have determined that your data is pre-summarized, based on the graph and the options you used. Therefore, try this as a workaround:

 

proc sort data=stress out=stress2; by descending group descending percent; run;

ods graphics on;
PROC SGPLOT DATA = stress2;
VBARPARM category=variable RESPONSE = percent / GROUP = endorsed SEGLABEL groupdisplay=stack;
YAXIS GRID LABEL = "Percentage";
RUN;
ods graphics off;

Hope this helps!

Dan

View solution in original post


All Replies
Solution
3 weeks ago
SAS Super FREQ
Posts: 925

Re: SAS - stacked bar graph

I have a hunch about why this happened, but I cannot verify that without your data. However, I think I have determined that your data is pre-summarized, based on the graph and the options you used. Therefore, try this as a workaround:

 

proc sort data=stress out=stress2; by descending group descending percent; run;

ods graphics on;
PROC SGPLOT DATA = stress2;
VBARPARM category=variable RESPONSE = percent / GROUP = endorsed SEGLABEL groupdisplay=stack;
YAXIS GRID LABEL = "Percentage";
RUN;
ods graphics off;

Hope this helps!

Dan

New Contributor
Posts: 2

Re: SAS - stacked bar graph

Thanks Dan. That was awesome and easy fix. I had done freq analysis for each variable and then summarized them in a table to produce stacked bar graph. I am not sure how to do it otherwise. I am still learning SAS and loving it for analysis at work at school both.

 

Thanks a lot!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 2 in conversation