multiple response tables

#1
I have a multiple response variable: race=participants can select more that one race.
race1
race2
race3
so on

I need to create a table in excel. I do not want to copy and paste every table from stata into excel. Is there a way to tab all these varable at once in one table?

Thank you,
Marvin
 
#2
Hi Marvin,

Is this just a one-way table? Would something like this work for you?

.table race1-race3, c(freq)

You might want to google "ian watson tabout" for some additional insight on moving tables to Excel.

Mike
 
#3
Hi Mike,

I think I wasn't clear. I have a multiple response variable. let say race1 race2 race3 .. race9. If I tab my race variable- tab1 race1- race9- I would have a table for each of my race variables. I am creating a chart in excel and I need just the number of the percentage of each one. That is:
race1 20
race2 40
race3 21
etc

SO I can make a frequency chart.

Thank you,
Marvin
 
#4
Hi Marvin,

It's a little difficult to be sure if I'm on the right track, but would something like this work for you? If not provide a little more info about your data.

. graph bar (count) var2, over(var1)

take care, Mike