SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Manage regression outputs

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 110
Accepted Solution

Manage regression outputs

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?


Accepted Solutions
Solution
‎03-02-2017 05:10 AM
PROC Star
Posts: 288

Re: Manage regression outputs

[ Edited ]

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.

View solution in original post


All Replies
Solution
‎03-02-2017 05:10 AM
PROC Star
Posts: 288

Re: Manage regression outputs

[ Edited ]

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 155 views
  • 0 likes
  • 2 in conversation