topic Re: Creating macro to run iterative regressions in SAS Programming

Creating macro to run iterative regressions

easygoing — Wed, 24 Aug 2016 20:59:43 GMT

Hello SAS experts,

I am a beginniner in SAS and need some help in performing multivaite analysis using SAS macro.

I have an unbalanced panel data by country (50 countries, sample period 2010-2014) as attached and each country has a number of banks by year.

I would like to run a multivariate regression by country as follows and have an output of coefficient estimates, standard errors, t-value, adjusted R square and N by country from each regression.

proc reg

model price = gain cashflow CPI

But I hope to find a more efficient way of performing analyses that allows running iterative regressions by country instead of running 50 times of regressions and put together each regressions restuls 50 times.

I greatly appreciate your help with this matter.

Thank you in advance!

Re: Creating macro to run iterative regressions

Reeza — Wed, 24 Aug 2016 21:18:09 GMT

Have you looked at BY group processing -

proc sort data=sashelp.class out=class; by sex;
run;

proc reg data=class;
by sex;
model weight = height age;
run;

Re: Creating macro to run iterative regressions

PGStats — Wed, 24 Aug 2016 21:19:18 GMT

Sort your data by country and add a BY country statement in proc reg. You will get a separate regression analysis for each country.

Re: Creating macro to run iterative regressions

easygoing — Wed, 24 Aug 2016 22:03:32 GMT

Thank you for your response.
It works in terms of running regressions for 50 different countries at one
time. Would there be any way to have coefficient estimates, standard
errors, t-value, adjusted R square and N by country in one table?
Thank you again!

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: Creating macro to run iterative regressions

easygoing — Thu, 25 Aug 2016 00:19:41 GMT

Thank you veru much for your advice.

In addition, I would like to have results by country, especially estimates, standard errors, t-value and adjusted rsquares in one table and tried the codes as follows. But it did not work. What would be wrong with my codes?

proc reg data= xx;
MODEL Price = gain cashflow CPI;
by country;
ods select DataSummary FitStatistics;
ods output ParameterEstimates = tt;
run;

proc print data=tt; noobs;
var Parameter Estimate Standard Error tValue;
run;

Re: Creating macro to run iterative regressions

Reeza — Thu, 25 Aug 2016 00:28:28 GMT

What does your log say is wrong with your code?

Re: Creating macro to run iterative regressions

easygoing — Thu, 25 Aug 2016 01:01:13 GMT

My log says as follows.

WARNING: Output 'ParameterEstimates' was not created. Make sure that the output object name,
label, or path is spelled correctly. Also, verify that the appropriate procedure
options are used to produce the requested output object. For example, verify that the
NOPRINT option is not used.
WARNING: Output 'FitStatistics' was not created. Make sure that the output object name, label,
or path is spelled correctly. Also, verify that the appropriate procedure options are
used to produce the requested output object. For example, verify that the NOPRINT
option is not used.
WARNING: Output 'DataSummary' was not created. Make sure that the output object name, label, or
path is spelled correctly. Also, verify that the appropriate procedure options are used
to produce the requested output object. For example, verify that the NOPRINT option is
not used.

Re: Creating macro to run iterative regressions

PGStats — Thu, 25 Aug 2016 01:59:39 GMT

Check the ODS Table Names section of the Details tab in the proc reg documentation. The procedure options that must be specified to get each ODS table are listed there.

Re: Creating macro to run iterative regressions

easygoing — Mon, 26 Sep 2016 20:30:41 GMT

I solved the problem. Thank you very much for all your advice!