topic How do I change panel headings in proc sgplot? in Graphics Programming

How do I change panel headings in proc sgplot?

abarnett313 — Thu, 21 Jul 2016 15:27:00 GMT

Greetings,

I am using Proc SGPanel to create two histograms for different levels of the same variable (named "LGBQ"). LGBQ is coded to have values of either 1 or 2; I have used Proc Format to indicate that 1 = Heterosexual and 2 = LGBQ. When I use Proc SGPanel, the two panels are labeled "LGBQ=1" and "LGBQ=2". Is there a way to have Proc SGPanel pull the formatted labels instead of the values for the variables? Or to alter the headings for each column? I'm using SAS Enterprise Guide 4.3. Any help or insight would be greatly appreciated.

I'm a relative SAS newbie and couldn't find any articles or posts that addressed this issue; apologies if there is one already that I missed.

Thanks,

Andrew

Re: How do I change panel headings in proc sgplot?

ballardw — Thu, 21 Jul 2016 15:37:46 GMT

Showing the code you used would help.

Did you actually use assign the format to the variable in either the data set or the SGPANEL? it would look like this:

Format LBGQ formatname. ;

Re: How do I change panel headings in proc sgplot?

djrisks — Thu, 21 Jul 2016 15:37:53 GMT

Greetings, I thought the formatted value will be shown automatically as long as you are also using the format statement? Have you used the format statement within your proc sgpanel?

Thanks

Re: How do I change panel headings in proc sgplot?

abarnett313 — Thu, 21 Jul 2016 16:10:39 GMT

I used this code for proc sgpanel:

proc sgpanel data=D1; panelby LGBQ / uniscale=all; histogram VictimLGBT; density VictimLGBT; run;

And I formatted the dataset using this statement (earlier in the program than proc sgpanel:

proc format; value LGBQ 1 = "Heterosexual" 2 = "LGBQ"; run;

Re: How do I change panel headings in proc sgplot?

abarnett313 — Thu, 21 Jul 2016 16:13:26 GMT

Ah. Now I see what you mean. I added a format statement [ format LGBQ LGBQ.; ], and it produced the desired results. Thank you!