Quartz | Level 8

## Proc SGPLOT adding diagonal line

Hi All,

I am working on some graphs and getting a funky result with sgplot. I'm plotting fecal results by day. Most subjects have 0 fecal culture at day 1, but when I add in the subject with >0 fecal culture, sgplot creates a diagonal line. Graph 1 shows that one subject has a fecal culture of 3 and instead of dropping to 0 on the rest of the days as is in the dataset, sgplot draws a diagonal line. Graph 2 shows how this subject's results should be shown. How do I force sgplot to represent the true values for this subject? I have tried to set 0 values to 0.1 for this subject and get the same results. I also do not want to take out this subject from the graph.

Thanks,

Sarah

1 ACCEPTED SOLUTION

Accepted Solutions
Opal | Level 21

## Re: Proc SGPLOT adding diagonal line

Yes, give the same line color attribute to all lines with LINEATTRS. You might also want to add NOAUTOLEGEND to prevent the production of a meaningless legend :

proc sort data=myData; by subject day; run;

proc sgplot data=myData noautolegend;

series y=CFU x=day / group=subject lineattrs=(color=darkblue);

run;

PG

PG
5 REPLIES 5
Super User

## Re: Proc SGPLOT adding diagonal line

Can you post your code as well, possibly some sample data?

Is your data sorted by anything?

Opal | Level 21

## Re: Proc SGPLOT adding diagonal line

Your code should have the following structure:

proc sort data=myData;

by subject day;

run;

proc sgplot data=myData;

series y=CFU x=day / group=subject;

run;

PG

PG
Quartz | Level 8

## Re: Proc SGPLOT adding diagonal line

Thanks PGStats, that worked to get rid of the diagonal. However, is there a way to make the groups all one color? There are >30 subjects and 30 color and line combinations.

Thanks,

Sarah

Opal | Level 21

## Re: Proc SGPLOT adding diagonal line

Yes, give the same line color attribute to all lines with LINEATTRS. You might also want to add NOAUTOLEGEND to prevent the production of a meaningless legend :

proc sort data=myData; by subject day; run;

proc sgplot data=myData noautolegend;

series y=CFU x=day / group=subject lineattrs=(color=darkblue);

run;

PG

PG
Super User

## Re: Proc SGPLOT adding diagonal line

With that many groups I might be tempted to go to SGPanel an produce multiple graphs as you may not be able to tell which values are obscured by lines tracing over one another especially with lots of integer values.

Discussion stats
• 5 replies
• 1908 views
• 3 likes
• 4 in conversation