Data visualization with SAS programming

PROC SGPLOT Attrid and Format label Interactions

Accepted Solution Solved
Reply
User
Posts: 1
Accepted Solution

PROC SGPLOT Attrid and Format label Interactions

I am trying to use the SGPLOT procedure to create a stacked horizontal bar chart with four categories and apply a color scheme using the attrid statement.

 

In order to get the four categories in the proper order (rather than alphabetical), each category was assigned a numeric variable (1-4) and a format statement is used to convert the numeric variable back into the category label.

 

The issue is that I can either get the format to work but the attrid statement won't work to assign the appropriate colors or the attrid statement works to assign the colors and I am left with (1,2,3,4) in my legend.

 

The first statement produces an output with the appropriate values for label but not the colors specified by the evh type

 

proc sgplot data=combined5 dattrmap=formatdw.evhstyle;
format value valfmt.;
hbar &sumvar. / response=pcs1 stat=sum
group=value groupdisplay=stack nooutline attrid=evh;
title "Primary Care Services by Type";
run;

SAS2.JPG

 

The second statement produces a graph with the appropriate colors but leaves (1,2,3,4) in the legend as the values used to order the stacked bars

 

proc sgplot data=combined5 dattrmap=formatdw.evhstyle;
hbar &sumvar. / response=pcs1 stat=sum
group=value groupdisplay=stack nooutline attrid=evh;
title "Primary Care Services by Type";
run;

sas1.JPG

Ideally, I'd like the bars stacked in the proper order, with the color scheme applied and the service types labeled in the legend. Thanks in advance for any help.


Accepted Solutions
Solution
‎11-22-2017 06:42 PM
Esteemed Advisor
Posts: 5,405

Re: PROC SGPLOT Attrid and Format label Interactions

Posted in reply to Ewilliamson

Use the formatted group values in your dattrmap dataset, sort your data by your numeric variable, and use grouporder=data in the hbar statement. 

PG

View solution in original post


All Replies
SAS Super FREQ
Posts: 496

Re: PROC SGPLOT Attrid and Format label Interactions

Posted in reply to Ewilliamson

I don't know the answer, and there is not enough code here for me to easily reconstruct what you are doing.  However, I can say that one of the standard legend tricks is to make an invisible plot that has the legend you want and overlay it with a visible plot that makes the graph that you want (and don't show the legend for it). 

 

Also, in either the latest release or the second latest, there is a legenditem statement that is very cool and lets you control precisely what is in the legend.  If no one posts better ideas, you might try those.

Super User
Posts: 22,874

Re: PROC SGPLOT Attrid and Format label Interactions

Posted in reply to Ewilliamson
It would be helpful if you can replicate this using a SASHELP table or provide some sample data so we can test solutions rather than make some generic suggestions.
Solution
‎11-22-2017 06:42 PM
Esteemed Advisor
Posts: 5,405

Re: PROC SGPLOT Attrid and Format label Interactions

Posted in reply to Ewilliamson

Use the formatted group values in your dattrmap dataset, sort your data by your numeric variable, and use grouporder=data in the hbar statement. 

PG
☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 286 views
  • 0 likes
  • 4 in conversation