BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
CynicalFire
Fluorite | Level 6
PROC SGPANEL NOAUTOLEGEND DATA=sdhouse;
    PANELBY Section8;
    SERIES X=LinTime Y=Housing / GROUP = ID LINEATTRS =(THICKNESS=1);
    keylegend;
RUN;

My code is listed above. My Y variable, Housing, has 3 levels. I would like to only have level = 1 used. Is there a way to make this work with PROC SGPANEL?

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

@CynicalFire wrote:
PROC SGPANEL NOAUTOLEGEND DATA=sdhouse;
    PANELBY Section8;
    SERIES X=LinTime Y=Housing / GROUP = ID LINEATTRS =(THICKNESS=1);
    keylegend;
RUN;

My code is listed above. My Y variable, Housing, has 3 levels. I would like to only have level = 1 used. Is there a way to make this work with PROC SGPANEL?


You can always restrict data with a data set option where clause such as (assuming the value is numeric)

 

PROC SGPANEL NOAUTOLEGEND DATA=sdhouse (where = (housing=1));
   PANELBY Section8;
   SERIES X=LinTime Y=Housing / GROUP = ID LINEATTRS =(THICKNESS=1);
   keylegend; 

RUN;

Many procedure will also allow a WHERE statement

PROC SGPANEL NOAUTOLEGEND DATA=sdhouse;
   where  housing=1;
   PANELBY Section8; 
   SERIES X=LinTime Y=Housing / GROUP = ID LINEATTRS =(THICKNESS=1); 
   keylegend; 
RUN;

View solution in original post

1 REPLY 1
ballardw
Super User

@CynicalFire wrote:
PROC SGPANEL NOAUTOLEGEND DATA=sdhouse;
    PANELBY Section8;
    SERIES X=LinTime Y=Housing / GROUP = ID LINEATTRS =(THICKNESS=1);
    keylegend;
RUN;

My code is listed above. My Y variable, Housing, has 3 levels. I would like to only have level = 1 used. Is there a way to make this work with PROC SGPANEL?


You can always restrict data with a data set option where clause such as (assuming the value is numeric)

 

PROC SGPANEL NOAUTOLEGEND DATA=sdhouse (where = (housing=1));
   PANELBY Section8;
   SERIES X=LinTime Y=Housing / GROUP = ID LINEATTRS =(THICKNESS=1);
   keylegend; 

RUN;

Many procedure will also allow a WHERE statement

PROC SGPANEL NOAUTOLEGEND DATA=sdhouse;
   where  housing=1;
   PANELBY Section8; 
   SERIES X=LinTime Y=Housing / GROUP = ID LINEATTRS =(THICKNESS=1); 
   keylegend; 
RUN;
Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 890 views
  • 0 likes
  • 2 in conversation