I have a lot of files which are originally tables. I want to restructure the dataset, basically transposing the table. That is, 2008 should be the second row and in the first row should contain the values from variable B. The dataset looks like this right now:
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str43 B double vD
""                                             2008
"U.S. statutory rate"                          -.34
"State income taxes, net of federal benefits"  -4.6
"Foreign tax rate difference"                   -.2
"Tax credits"                                   -.2
"Non-deductible items"                          4.4
"Valuation allowance"                          25.5
"Change in tax liability reserves"               .6
"Expired net operating losses"                   .4
"Other"                                          .6
"ETR"                                         -.075
end
Is there a simple trick to do this?