The following table is the format of the result I want by running Censored Tobit regression
. | Dependent | Variables | . | . | . |
Independent variables | Lib | Price | Dbu | Exp | Rtrn |
Intercept | *** | *** | *** | *** | *** |
Assets | *** | *** | *** | *** | *** |
Equity | *** | *** | *** | *** | *** |
debt | *** | *** | *** | *** | *** |
LTD | *** | *** | *** | *** | *** |
Mort | *** | *** | *** | *** | *** |
R^2 | *** | *** | *** | *** | *** |
No of observations | *** | *** | *** | *** | *** |
My data Example: The following table shows the data too runTobit Model
Assets | Equity | Debt | LTD | Mort | Lib | Price | Dbu | Exp | Rtrn |
5.632 | 1.983 | 2.1 | 1.2 | 2.179 | 2.449 | 5.25 | 7.429 | 4.432 | 23.268 |
8.529 | 6.095 | 2.683 | 0.95 | 2.039 | 0 | 2.75 | 0 | 8.529 | 23.45475 |
8.241 | 6.482 | 2.683 | 0.6 | 5.964 | 0 | 4.375 | 0 | 8.241 | 36.05438 |
13.99 | 6.665 | 2.683 | 4.682 | 6.781 | 0 | 4.25 | 0 | 59.4575 | |
14.586 | 7.458 | 2.683 | 3.75 | 10.959 | 0 | 2.75 | 13.709 | 14.586 | 0 |
16.042 | 7.643 | 2.683 | 5.478 | 10.411 | 8.399 | 1.75 | 12.161 | 0 | 0 |
16.28 | -0.194 | 2.683 | 0.104 | 9.467 | 16.474 | 0.75 | 10.217 | 0 | 12.21 |
10.109 | -0.416 | 2.683 | 0.076 | 8.102 | 10.525 | 14.75 | 0 | 0 | 149.1078 |
73.758 | 25.682 | 2.357 | 20.909 | 7.249 | 48.076 | 13.625 | 20.874 | 73.758 | 1004.953 |
83.075 | 29.721 | 2.566 | 23.4 | 4.303 | 53.354 | 7.625 | 0 | 83.075 | 0 |
113.653 | 42.423 | 3.942 | 29.412 | 2.323 | 71.23 | 9.375 | 0 | 113.653 | 0 |
137.228 | 81.085 | 6.007 | 13.04 | 23.4 | 0 | 18.5 | 41.9 | 0 | 2538.718 |
155.405 | 87.385 | 3.098 | 16.415 | 29.412 | 19.32 | 25.875 | 55.287 | 0 | 2760.992 |
The first 5 are independent variables and the last 5 are dependent variables. Is there any SAS code to run the Tobit model so that I can get the results similar format in Table 1 above?
Generic answer to somewhat generic question: If you have a very specific report layout requirement then the steps are going to be:
1) run the models
2) creating output data sets of the required elements
3) combine the data sets
4) generate the report table(s)
Without your data or all of the required model parameters and options you need can't go much further than that.
Is your "example data" the result from the model? It appears not.
I have no idea what options you may want or need or even which specific procedure you may need.
Are you actually asking for how to run any tobit model?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: