topic Re: Create separate keylegends in sgpanel in Graphics Programming

Create separate keylegends in sgpanel

Jason2020 — Tue, 07 Feb 2023 18:19:24 GMT

I would like to have 2 keylegends in a 2-panel graph in Proc SGPANEL (see code below). As you may note in the figure below, the keylegends is not sorted by the demographics1 or demographics2. Sorting the data by these 2 variables did not make a difference. Is there any way to make 2 separate legends by the variable demographics1: one for the gender, and the other for race?

Thank you.

proc sgpanel;

styleattrs datacolors=(blue lightred grey brown white)

datalinepatterns=(solid);

panelby parameter Demographics1 /novarname noheaderborder

headerattrs=(size=18pt weight=bold)

layout=lattice colheaderpos=bottom;

vbarparm category=threshold response=prevalence /

group=Demographics2 groupdisplay=cluster

dataskin=crisp grouporder=ascending;

colaxis discreteorder=data

display=(noticks nolabel)

valueattrs=(size=16pt weight=bold);

rowaxis label='Percent'

labelattrs=(size=24pt weight=bold)

valueattrs=(size=16pt weight=bold)

values=(0 to 80 by 20);

keylegend /position=top autoitemsize down=3

title="" sortorder=ascending

titleattrs=(Family=Arial Size=12 Weight=Bold)

valueattrs=(Family=Arial Size=18 Weight=Bold);

run;

Re: Create separate keylegends in sgpanel

DanH_sas — Tue, 07 Feb 2023 21:01:29 GMT

Try this EXCLUDE trick in the KEYLEGEND statement and see if it works for you:

proc sgpanel;
styleattrs datacolors=(blue lightred grey brown white)
   datalinepatterns=(solid);
panelby parameter Demographics1 /novarname noheaderborder
   headerattrs=(size=18pt weight=bold)
   layout=lattice colheaderpos=bottom;
vbarparm category=threshold response=prevalence /
  group=Demographics2 groupdisplay=cluster name="bar"
   dataskin=crisp grouporder=ascending;
colaxis discreteorder=data
  display=(noticks nolabel)
  valueattrs=(size=16pt weight=bold);
rowaxis label='Percent'
  labelattrs=(size=24pt weight=bold)
  valueattrs=(size=16pt weight=bold)
  values=(0 to 80 by 20);
keylegend "bar" / position=topleft autoitemsize across=1
  title="" sortorder=ascending
  exclude=("Female" "Male")
  titleattrs=(Family=Arial Size=12 Weight=Bold)
  valueattrs=(Family=Arial Size=18 Weight=Bold);
keylegend "bar" / position=topright autoitemsize across=1
  title="" sortorder=ascending
  exclude=("Black" "Mexican" "White")
  titleattrs=(Family=Arial Size=12 Weight=Bold)
  valueattrs=(Family=Arial Size=18 Weight=Bold);
run;

Re: Create separate keylegends in sgpanel

Jason2020 — Tue, 07 Feb 2023 22:06:23 GMT

Hi Dan,

It actually worked. I did however get an error message, that "topright" and "topleft" were not acceptable, so I used "top" and "bottom" instead. Here is how the figure looks now.

Thank you very much for your help.

Re: Create separate keylegends in sgpanel

DanH_sas — Tue, 07 Feb 2023 23:08:53 GMT

Ah, yes...sorry about that. Those values are supported in SGPLOT, but not SGPANEL. The way you have them arranged looks better anyway :-).