topic Re: Proc SGPLOT adding diagonal line in Graphics Programming

Proc SGPLOT adding diagonal line

sarahsasuser — Sun, 11 Jan 2015 21:06:23 GMT

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

Re: Proc SGPLOT adding diagonal line

Reeza — Sun, 11 Jan 2015 23:27:04 GMT

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

Is your data sorted by anything?

Re: Proc SGPLOT adding diagonal line

PGStats — Mon, 12 Jan 2015 02:00:51 GMT

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;

Re: Proc SGPLOT adding diagonal line

sarahsasuser — Mon, 12 Jan 2015 03:16:54 GMT

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

Re: Proc SGPLOT adding diagonal line

PGStats — Mon, 12 Jan 2015 03:54:51 GMT

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;

Re: Proc SGPLOT adding diagonal line

ballardw — Mon, 12 Jan 2015 15:52:18 GMT

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.