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
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 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.