topic Re: How to add a mean or median smooth line to Spagetti plot? in SAS Programming

How to add a mean or median smooth line to Spagetti plot?

Denali — Sun, 19 Apr 2020 01:21:58 GMT

Hi,

Attached is the spagetti plot that I made. Does anyone know how to add a smooth line (mean or median) to this figure?

Below is my SAS code:

proc sgplot data=test2;
where AKI=1 & survive_5yr = 1;
series x=year y=eGFR_a /group=ID ;
keylegend 'grouping' / type=linecolor;
label eGFR_a = eGFR year = Year;
run;

Many thanks in advance!

Re: How to add a mean or median smooth line to Spagetti plot?

ChrisNZ — Sun, 19 Apr 2020 03:54:32 GMT

1. Do not attach MS Office files, many will/can not download these.

2. Include images as ... images, there's a button for that

3. Did you try adding a series statement?

4. It's a good idea to include code that we can run. For example using one of the sample data sets in the SASHELP library.

Re: How to add a mean or median smooth line to Spagetti plot?

Denali — Sun, 19 Apr 2020 05:01:40 GMT

Sorry, I didn’t see the imagine button. Where is it?
What series can I add for the smooth line? I would like to add a mean or median into the plot.

Re: How to add a mean or median smooth line to Spagetti plot?

ChrisNZ — Sun, 19 Apr 2020 07:15:36 GMT

1. The camera button
2. Calculate the mean and plot it

Re: How to add a mean or median smooth line to Spagetti plot?

Ksharp — Sun, 19 Apr 2020 10:11:39 GMT

Maybe it is not what you want.But could try LOESS

loess x=year y=eGFR_a ;

Re: How to add a mean or median smooth line to Spagetti plot?

Ksharp — Sun, 19 Apr 2020 10:17:25 GMT

Or try quantile regression PROC QUANTREG:

https://blogs.sas.com/content/iml/2018/08/13/quantile-regression-chess-ratings.html

https://blogs.sas.com/content/iml/2018/08/06/score-quantile-regression-sas.html

Re: How to add a mean or median smooth line to Spagetti plot?

ballardw — Mon, 20 Apr 2020 15:18:12 GMT

Mean or median of what exactly?

How many lines of spaghetti (group=ID values) are there? If you have 10 lines are you looking to add 10 "means"?

You

I might be tempted to add:

reg x=year y=eGFR_a /group=ID ;

to show a "best fit" line associated for each group.

Or summarize you data to find the desired mean or median and use a REFLINE statement to plot those values.

Re: How to add a mean or median smooth line to Spagetti plot?

Denali — Mon, 04 May 2020 04:27:19 GMT

proc sgplot data=test2;
where AKI=1 & survive_5yr = 1;
series x=year y=eGFR_a /group=ID ;
loess x=year y=eGFR_a ;
keylegend 'grouping' / type=linecolor;
label eGFR_a = eGFR year = Year;
run;

It does not look like what I expected. I would like to plot a mean in the middle of the figure, if possible....

Re: How to add a mean or median smooth line to Spagetti plot?

Ksharp — Mon, 04 May 2020 11:36:50 GMT

Well. Could you calculate mean of eGFR_a within a year .And plot it on your own ?