Dear Statalisters,
I have two simple questions concerning how to make tables in Stata:
1) I want to make a table with the following setup:
Informal firm Formal firm
Male Female Male Female
myvar1 36.21 40 23.76 ...
myvar2 ... ... ... ...
myvar3 ... ... ... ...
I have been putting these tables together by calculating each variable
separately with the following command:
by firm_infor fem : sum myvar1
by firm_infor fem : sum myvar2
by firm_infor fem : sum myvar3
and then taking the relevant mean statistic and transfering the values
into Excel. However this takes a long time.
2) How would I do the same table, but for dummy variables (with 0 or 1
as potential responses) in which I do not want the mean, but just the
number of firms that responded 1 to a particular variable. I have been
doing the following:
by firm_infor fem : tab myvar4
by firm_infor fem : tab myvar5
by firm_infor fem : tab myvar6
and then just taking the statistic for those firms that responded 1.
This takes a long time too.
I hope this is clear enough. This is the first time I am posting a
question on Statalist, so please let me know if you need any further
information.
Warm regards,
Sina
--
Sina Joy Grasmann
917 Columbia Road
Washington, D.C. 20001
USA
[email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
