Data visualization with SAS programming

Proc SGPLOT adding diagonal line

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

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

Attachment
Attachment

Accepted Solutions
Solution
‎01-11-2015 10:54 PM
Respected Advisor
Posts: 4,609

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

View solution in original post


All Replies
Grand Advisor
Posts: 17,428

Re: Proc SGPLOT adding diagonal line

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

Is your data sorted by anything?

Respected Advisor
Posts: 4,609

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

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
Respected Advisor
Posts: 4,609

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
Grand Advisor
Posts: 10,239

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.

☑ This topic is SOLVED.

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

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