st: Capturing text and numbers

["Narahari H.S." <naraharihs@yahoo.co.in>]

Hello all,

I am trying to summarize the VIFs after running a few regressions. A sample code to capture the 3 highest VIFs is below

mat input VIF=(0,0,0)
reg y x1 x2 x3 x4 x5
est store result1
qui vif,unc
mat VIF=VIF\(r(vif_1),r(vif_2),r(vif_3))
reg y1 x1 x2 x3 x6 x7
est store result2
qui vif,unc
mat VIF=VIF\(r(vif_1),r(vif_2),r(vif_3))

Ideally, I would like to have the output in the following format

resultname varname1 vif1 varname2 vif2 varname3 vif3

I cannot use matrices to get the above output as I cannot input text into matrices. If I use --caplog using `e(_estimates_name)'_VIF : vif,unc--, I get a separate text file for each regression but not a summary as desired above.

Please suggest a code for getting the desired output in a summary format.

Thanks in advance
Hari

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/