Create separate keylegends in sgpanel

[Jason2020]

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;

[DanH_sas · Accepted solution]

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;

[Jason2020]

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.

[DanH_sas]

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