Manage regression outputs

Demographer — Wed, 01 Mar 2017 13:14:22 GMT

Hello,

I have logit regression outputs for 28 countries * 2 sex. The output format is the same, because the independant variables and categories are the same as well as the dependant variable (labor force participation, 0-1). I would like to manage these outputs in order to have a single table stating the estimated parameters in column and the independent variables in row. Is it possible or do I need to copy-paste in Excel?

Re: Manage regression outputs

collinelliot — Wed, 01 Mar 2017 17:00:15 GMT

Please do NOT copy and paste into Excel. That would make me cry.

I'm not sure how you're running all of these models, but one thing you can do is to save the parameter estimates as data sets using ods output.

The basic syntax would be (using proc logistic):

ods output parameterEstimates = your_data_set_name;

proc logistic...

ods output close;

If you're running in a macro, you can do something to give the output data set a unique name and then concatentate or whatever. Your options are many, so please don't copy paste. 🙂 If you have some example code of how you're running the models, I could give you more specific examples of what to do.

topic Manage regression outputs in SAS Data Management

Manage regression outputs

Re: Manage regression outputs