topic Re: Output the intercept and the corresponding standard error estimated by proc reg to a data set in Statistical Procedures

Output the intercept and the corresponding standard error estimated by proc reg to a data set

DavyJones — Mon, 06 Nov 2017 01:42:14 GMT

Hi,

I use the following code to regress var1 on var2 and var3, and then output the intercepts to model1 dataset.

proc reg data=have outest=model1 (keep=intercept); model var1=var2 var3; run;

My question is that if I could adjust this code so that model1 includes the intercept as well as its corresponding standard error and/or p-value and the number of observations used for estimation.

Thanks.

Re: Output the intercept and the corresponding standard error estimated by proc reg to a data set

PGStats — Mon, 06 Nov 2017 05:26:54 GMT

Use ODS OUTPUT to capture the output tables:

proc reg data=sashelp.class plots=none;
model weight = age height;
ods output parameterEstimates=pe Nobs=nobs;
run;

data stats;
set pe(where=(Variable="Intercept"));
set nobs(where=(Label="Number of Observations Used"));
run;

Re: Output the intercept and the corresponding standard error estimated by proc reg to a data set

Rick_SAS — Mon, 06 Nov 2017 14:40:46 GMT

Sure. Use the TABLEOUT option on the P{ROC REG statement:

proc reg data=sashelp.class outest=model1 tableout plots=none; 
model weight=height age; 
quit;

proc print; run;

Re: Output the intercept and the corresponding standard error estimated by proc reg to a data set

DavyJones — Wed, 08 Nov 2017 15:57:38 GMT

Thanks.