topic Residual plots in SAS in Statistical Procedures

Residual plots in SAS

PeroGti — Thu, 04 May 2023 18:16:18 GMT

Dear SAS experts,

I have a problem with the residual graph, I need to get this graph bellow in the picture;

Residual values for each country and connect them with line between years

does someone know the code for residuals plots with multiple countries and connected with line

Thank you in advance.

best regards,

Re: Residual plots in SAS

PaigeMiller — Thu, 04 May 2023 18:18:08 GMT

PROC SGPLOT can do this. Example

Re: Residual plots in SAS

Reeza — Thu, 04 May 2023 18:22:36 GMT

Show the code used to create the model and output.
Ideally, sample data so we could replicate would be ideal.

In general, this is easy enough to do using SGPLOT and the output dataset from the regression. Guessing, something like the following;

proc sgplot data=residuals;
series x=godina y=residual / group=drzava markers;
run;

Re: Residual plots in SAS

PeroGti — Thu, 04 May 2023 18:39:40 GMT

Hello,

I'm using this codes to create the model and output;

/*SAS kod*/
Proc means data=WORK.SAS_project;
var 'Housing_Loans_[millions]_y'n GDP_per_capita_x Active_population_x wages_Eurostat_x;
by drzava;
run;

/*SAS kod*/
data WORK.SAS_project; set WORK.SAS_project;
'Housing_Loans_[millions]_y'n=log('Housing_Loans_[millions]_y'n);
Active_population_x=log(Active_population_x);
wages_Eurostat_x=log(wages_Eurostat_x);
GDP_per_capita_x=log(GDP_per_capita_x);
run;

/*SAS code*/
title"Model fiksnih efekata";
proc panel data=WORK.SAS_project;
id drzava Year;
model 'Housing_Loans_[millions]_y'n= Active_population_x GDP_per_capita_x wages_Eurostat_x /fixone printfixed;
run;

now I need to create that graph for residual values on the y axis for each country, if would be easier to send a file maybe?

thank you in andvance

best regards

Re: Residual plots in SAS

Reeza — Thu, 04 May 2023 18:42:15 GMT

Add the following to your proc panel.

output out=residuals r=residual;

And then try the code I posted replacing 'godina' with year.

Re: Residual plots in SAS

PeroGti — Thu, 04 May 2023 19:13:58 GMT

hello,

I have tried the code and the next error appears:

proc sgplot data=WORK.SAS_project;
series x=Year y=residual / group=drzava markers;
ERROR: Variable RESIDUAL not found.
run;

do You know why is something wrong in the code?

Re: Residual plots in SAS

PeroGti — Thu, 04 May 2023 19:15:55 GMT

this is the code that I write:

proc panel data=WORK.SAS_project;
id drzava Year;
model 'Housing_Loans_[millions]_y'n= Active_population_x GDP_per_capita_x wages_Eurostat_x /fixone printfixed;
output out=residual r=residual;
run;
proc sgplot data=WORK.SAS_project;
series x=Year y=residual / group=drzava markers;
run;

Re: Residual plots in SAS

PeroGti — Thu, 04 May 2023 20:15:57 GMT

the closest results corresponding to the graph above I get with next code:

/*SAS code*/
title"Model fiksnih efekata";
symbol value=circle;
proc reg data=WORK.SAS_project;
model Year= Active_population_x GDP_per_capita_x wages_Eurostat_x ;
plot residual. * predicted.;
by drzava;
run;

but as you can see in the picture bellow the results I get is for each country separately (I need all together in one graph) and additionally I don't know to connect the dots with line in this code

if someone knows please help

Re: Residual plots in SAS

Reeza — Thu, 04 May 2023 20:54:47 GMT

You named the output of the data set with the residuals (out=residual).

Then for the plotting step you use the original data set (data=sas_project), not the new one created with the residuals. Review the code I've posted and compare for the differences.

Re: Residual plots in SAS

PeroGti — Thu, 04 May 2023 21:06:27 GMT

thank you very much 🙂