Can I use a format to label sgpanel cell headings?

wernie — Thu, 15 Jun 2017 15:37:52 GMT

I'm creating a series of scatterplots using proc sgpanel. I want them to be organised by my population categories, so I created a new variable to use a number so they're in the proper order. The thing I want to change is the heading in each cell. I took out the variable name, so now it just shows '1', '2', etc. However, I want them to say 'Total population, 5k', 'Total population, 10k', etc. Is there a way to do this? Or do I have to set it up a certain way before doing proc sgpanel? Thanks!

data want;
   set want;
        if series ='tot5k' then nseries=1;
        else if series='tot10k' then nseries=2;
        else if series='tot15k' then nseries=3;
run;

proc format;
   value nseries   1='Total population, 5k'
                               2='Total population, 10k'
                               3='Total population, 15k';
run;

ods graphics / antialias=on antialiasmax=4300 subpixel=on;
proc sgpanel data=want;
   panelby nseries / novarname columns=4;
   scatter x=case y=measure;
   colaxis label='Cases';
   rowaxis label='Measure';
   refline 30 / axis=y label=('Cut-point');
run;

Re: Can I use a format to label sgpanel cell headings?

DanH_sas — Thu, 15 Jun 2017 15:44:14 GMT

Just adding the FORMAT statement on the proc should do it for you:

proc sgpanel data=want;

format nseries nseries.;
   panelby nseries / novarname columns=4;
   scatter x=case y=measure;
   colaxis label='Cases';
   rowaxis label='Measure';
   refline 30 / axis=y label=('Cut-point');
run;

Re: Can I use a format to label sgpanel cell headings?

wernie — Thu, 15 Jun 2017 15:46:13 GMT

Ah, yes! That should have been obvious, but for some reason, it wasn't. Worked perfectly. Thanks 🙂

topic Can I use a format to label sgpanel cell headings? in Graphics Programming

Can I use a format to label sgpanel cell headings?

Re: Can I use a format to label sgpanel cell headings?

Re: Can I use a format to label sgpanel cell headings?