topic How do I get predicted values given the regression coefficients and a new dataset? in SAS Programming

How do I get predicted values given the regression coefficients and a new dataset?

inbalia — Tue, 05 Nov 2019 19:01:35 GMT

DATA data1;
INPUT obs age healthscore cost access$;
DATALINES;
1 37.1744 2.74061 918.92 2
2 56.8510 0.98697 7.29 1
3 62.6610 2.18619 1322.09 1
4 31.3702 3.80720 930613.57 4
5 60.0573 2.12735 972069.19 2
;
RUN;

PROC GLM DATA=data1;
CLASS access;
MODEL cost= healthscore access age/ SOLUTION;
RUN;

DATA data2;
INPUT obs age healthscore access$;
DATALINES;
1 62.6610 2.18619 1
2 60.0573 2.12735 2
3 61.6390 2.06955 1
4 33.8573 4.19116 3
5 47.2659 1.12857 2
;
RUN;

So I have all regression coefficients from data 1, but now I want to get the predicted values (ideally, the sum of predicted values) when I plug in data2 to the pre-existing regression model. I was wondering if there is any procedure to do this.

I really appreciate any help.

Re: How do I get predicted values given the regression coefficients and a new dataset?

PaigeMiller — Tue, 05 Nov 2019 19:28:59 GMT

Either PROC SCORE; or create a new data set by appending data2 to data1, in such a way that COST is missing for the data2 records; then re-run PROC GLM on this new dataset.

Re: How do I get predicted values given the regression coefficients and a new dataset?

Reeza — Tue, 05 Nov 2019 19:28:38 GMT

PROC PLM

https://documentation.sas.com/?docsetId=statug&docsetVersion=15.1&docsetTarget=statug_plm_examples01.htm&locale=en

PROC SCORE

https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_score_examples02.htm&docsetVersion=15.1&locale=en

CODE statement + data step

https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_glm_syntax05.htm&docsetVersion=15.1&locale=en

@inbalia wrote:
DATA data1;
INPUT obs age healthscore cost access$;
DATALINES;
1 37.1744 2.74061 918.92 2
2 56.8510 0.98697 7.29 1
3 62.6610 2.18619 1322.09 1
4 31.3702 3.80720 930613.57 4
5 60.0573 2.12735 972069.19 2
;
RUN;

PROC GLM DATA=data1;
CLASS access;
MODEL cost= healthscore access age/ SOLUTION;
RUN;

DATA data2;
INPUT obs age healthscore access$;
DATALINES;
1 62.6610 2.18619 1
2 60.0573 2.12735 2
3 61.6390 2.06955 1
4 33.8573 4.19116 3
5 47.2659 1.12857 2
;
RUN;
So I have all regression coefficients from data 1, but now I want to get the predicted values (ideally, the sum of predicted values) when I plug in data2 to the pre-existing regression model. I was wondering if there is any procedure to do this.

I really appreciate any help.

Re: How do I get predicted values given the regression coefficients and a new dataset?

PGStats — Tue, 05 Nov 2019 19:44:20 GMT

Add your data2 data with data1 and request predicted values. Doesn't work so well for your example data but should do better for your full data, if the model makes sense :

data data3;
set data1 data2;
run;

PROC GLM DATA=data3;
CLASS access;
MODEL cost= healthscore access age/ SOLUTION;
output out=data4 predicted=predCost;
RUN;

Look at data4 for predicted values.

Re: How do I get predicted values given the regression coefficients and a new dataset?

inbalia — Tue, 05 Nov 2019 20:16:30 GMT

Thank you very much! I am new to SAS and couldn't figure out PROC SCORE yet, but this worked wonderfully.