## Proc SGPLOT adding diagonal line

Solved
Frequent Contributor
Posts: 106

# 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

Accepted Solutions
Solution
‎01-11-2015 10:54 PM
Esteemed Advisor
Posts: 5,129

## Re: Proc SGPLOT adding diagonal line

Posted in reply to sarahsasuser

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

All Replies
Super User
Posts: 21,546

## Re: Proc SGPLOT adding diagonal line

Posted in reply to sarahsasuser

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

Is your data sorted by anything?

Esteemed Advisor
Posts: 5,129

## Re: Proc SGPLOT adding diagonal line

Posted in reply to sarahsasuser

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
Frequent Contributor
Posts: 106

## 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

Solution
‎01-11-2015 10:54 PM
Esteemed Advisor
Posts: 5,129

## Re: Proc SGPLOT adding diagonal line

Posted in reply to sarahsasuser

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
Posts: 12,148

## Re: Proc SGPLOT adding diagonal line

Posted in reply to sarahsasuser

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.

🔒 This topic is solved and locked.

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

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