Data visualization with SAS programming

Can I use a format to label sgpanel cell headings?

Accepted Solution Solved
Reply
Contributor
Posts: 32
Accepted Solution

Can I use a format to label sgpanel cell headings?

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;


Accepted Solutions
Solution
a week ago
SAS Super FREQ
Posts: 876

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

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;

View solution in original post


All Replies
Solution
a week ago
SAS Super FREQ
Posts: 876

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

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;

Contributor
Posts: 32

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

Ah, yes! That should have been obvious, but for some reason, it wasn't. Worked perfectly. Thanks Smiley Happy
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 43 views
  • 1 like
  • 2 in conversation