Manage regression outputs

[Demographer]

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?

[collinelliot · Accepted solution]

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.