Hi all,
Could someone please help me with an easy way to put frequencies
distribution output in a table?
What I want to do is to fill the following table of male and females
distribution of education attainment in each IQ score quintile( eg. to
calculate the percentages shown for quin tile 1 below)
___________________________________________
male female
(%) (%)
IQ score quintile 1 100.00 100.00
a. high school graduates and lower 80.00 85.00
b. some college 10.00 10.00
c. college graduates 8.00 6.00
d. advanced degrees 2.00 4.00
IQ score quintile 2
a. high school graduates and lower
b. some college
c. college graduates
d. advanced degrees
IQ score quintile 3
a. high school graduates and lower
b. some college
c. college graduates
d. advanced degrees
..........................................
__________________________________________
If I use command like:
. by IQquintile: tabulate education if male==1
. by IQquintile: tabulate education if female==1
(variable "IQquintile" means IQ score quintile. "education" is the
category variable for the four education groups seen above. )
I could get the numbers I want to fill the above table. But I need to
copy and paste each number into the table or type the numbers one by
one. This process takes time, if there are lots of groups. So, I
was wondering if there's any easier way to do this.
Thanks for your help!
Mandy
*
* 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/
