Can I use a format to label sgpanel cell headings?

[wernie]

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;

[DanH_sas · Accepted solution]

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;

[wernie]

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