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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.