Data visualization with SAS programming

Fitplot with Multiple Regression?

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Fitplot with Multiple Regression?

Hello,

I understand fitplot is not an option with Proc Reg when you have a multi-variable model.  But what do I do if I want to plot the fitted values vs the actual values?  Is there any work around that provides a similar look/feel?  I used the output function to create a new dataset with the predicted values and tried plotting those (see code below), but when I tried to plot the fitted (yhat) values as a series the line was erratic (see attached).

ods graphics on;

proc sgplot data = fitted_model;

scatter X =x1 Y=Y /markerattrs =(color = blue);

series X =x1 Y=yhat /lineattrs =(color = red);

run;

quit;Screen Shot 2014-01-18 at 10.30.13 PM.png


Accepted Solutions
Solution
‎01-18-2014 11:39 PM
Respected Advisor
Posts: 4,606

Re: Fitplot with Multiple Regression?

If you want to show the linear relationship between x1 and Y then you should sort your data BEFORE doing the regression :

proc sort data=myData; by my01variable x1; run;

proc reg data=myData ...;

....

run;

 

ods graphics on;

proc sgplot data = fitted_model;

scatter X =x1 Y=Y / markerattrs =(color = blue);

series X =x1 Y=yhat / group=my01variable lineattrs =(color = red);

run;

where my01variable is the dummy variable that generates the two lines in the x1-Y relationship.

PG

PG

View solution in original post


All Replies
Respected Advisor
Posts: 4,606

Re: Fitplot with Multiple Regression?

If you want actual by fitted (which is not a FITPLOT but a OBSERVEDBYPREDICTED plot), seems like you should be plotting

scatter X =Yhat Y=Y / markerattrs =(color = blue);

and no series.

PG

PG
Solution
‎01-18-2014 11:39 PM
Respected Advisor
Posts: 4,606

Re: Fitplot with Multiple Regression?

If you want to show the linear relationship between x1 and Y then you should sort your data BEFORE doing the regression :

proc sort data=myData; by my01variable x1; run;

proc reg data=myData ...;

....

run;

 

ods graphics on;

proc sgplot data = fitted_model;

scatter X =x1 Y=Y / markerattrs =(color = blue);

series X =x1 Y=yhat / group=my01variable lineattrs =(color = red);

run;

where my01variable is the dummy variable that generates the two lines in the x1-Y relationship.

PG

PG
New Contributor
Posts: 2

Re: Fitplot with Multiple Regression?

THANK YOU!!!  Didn't realize I had to sort it...was driving me NUTS!!!!

Post a Question
Discussion Stats
  • 3 replies
  • 464 views
  • 0 likes
  • 2 in conversation