I am trying to find the best Stata command to export descriptive information into an excel table...but I'm having trouble. I obtained the -desctable- package but when I run even the example tables from the -desctable- help file, I receive errors about an "invalid name". I am able to open an exported excel file despite this error but it shows only the variable names (no values)...I attached a screenshot. I'm not sure what is going wrong. Any suggestions?
My Data: I am examining immigrant student's age-at-arrival in the US (variable code: schaaa) and their college-going outcomes (variable code: clg4). I started by trying out the -desctable- example code from the help file but I cannot get it to work. I also tried the -desctable- command with my own variables and I have the same issue as with the example code, where I get an excel file with only the variable names, no values.
Desctable Syntax: desctable i.clg4 i.stusex if subpop11==1, filename("tabletjes") group(schaaa) stats(count)
My end goal: is to export a table that will look something like this (I normally use many "tab" commands to get this information but I want to create one table with one command if possible):
US born (%) (count) |
Pre-Sch Arrival | Elem.Sch Arrival | Mid.Sch Arrival | High Sch.Arrival | Total (count) | |
Enrolled in 4yr college | 37% 6,836 (count) |
51% 253 (count) |
41% 201 (count) |
37% 65 (count) |
32% 29 (count) |
7,384 |
Female | 50% 9,548 (count) |
55% 288 (count) |
49% 255 (count) |
49% 96 (count) |
49% 54 (count) |
...etc. |
…etc. |
Thank you so much for your time!
0 Response to How to export descriptive statistics (-desctable- not working)
Post a Comment