Exporting tabulation from stata to excel including a column with and another without value labels

Hi All,

I'd like to export a simple descriptive frequency table from stata to excel. My variable is 'state', a numeric float. So far I have been using the putexcel command with the following code:

Code:

putexcel set myfile, replace                    
tab2xl state using myfile, col(1) row(1)
putexcel close

This gets me the following excel table:
Array


I can't seem to amend the command to get an extra column between 'state' and 'Freq' which includes the non-label numeric values of the variable 'state'. Any suggestions?

Share on FacebookPlus on Google+