Graphics Programming

Data visualization using SAS programming, including ODS Graphics and SAS/GRAPH. Charts, plots, maps, and more!
BookmarkSubscribeRSS Feed
Naviava1973
Fluorite | Level 6

Hi All,

I would like to generate a spaghetti plot for individuals on follow-up (having a continuous outcome)  and thereafter overlay an overall line of median (with quartile ranges) providing a summary of the outcome measures at each visit. I would also like to join the median values from baseline to the last visit (have 6 visits).

I can do the spaghetti plot fine without difficulty but I was wondering if someone can point me to a similar example.

 

My code so far looks like this:

 

proc sgplot data=ec noautolegend;
series x=years_on_follow_up y=cd4 / group=studyid LINEATTRS=(color=black pattern=1);
reg x=year y=cd4 / nomarkers lineattrs=(color=red);

xaxis label = "Years on follow-up";
yaxis label = "CD4 Count" ;
run;

 

Any thoughts and suggestions will be appreciated.

 

Ken

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

You can add (overlay) multiple graphs on the same plot, so its just a matter of adding the data you want to the dataset, and adding additional plot statements.  Assume that your data contains median_base median_visit in your data, then you could just add:

proc sgplot data=ec noautolegend;
  series x=years_on_follow_up y=cd4 / group=studyid LINEATTRS=(color=black pattern=1);
  reg x=year y=cd4 / nomarkers lineattrs=(color=red);
  series x=median_base y=median_visit;
xaxis label = "Years on follow-up";
yaxis label = "CD4 Count" ;
run;

Or something like that to get the extra line.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 909 views
  • 1 like
  • 2 in conversation