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?
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.