Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: ouput tables using command 'display'


From   "Hui Wang" <jackie_stata@hotmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: ouput tables using command 'display'
Date   Sun, 29 Jan 2006 23:05:32 +0000

Hi, Guys,

I am trying to do a table contenting condictional counting results in each cell. To output the table automatically, I want to save the count result in macros and then use 'display' to show them in rows and columns.

The following is the main code. Where each row is the individual's current age and each column is the age at marriage, so that the number in row i and column j represents the number of people who is i years old now got married when he is j years old.

******Counting*********************************************
forvalue i=12/51 {
forvalue j=11/38 {
count if age==`i' & marr_age==`j'
local t4a_`i'`j'=r(N)
}
}

*****Display***********************************************
forvalue i=12/51 {
display `t4a_`i'11' "," `t4a_`i'12' "," `t4a_`i'13' "," `t4a_`i'14' "," `t4a_`i'15' "," `t4a_`i'16' "," `t4a_`i'17' "," `t4a_`i'18' "," `t4a_`i'19' "," `t4a_`i'20' "," `t4a_`i'21' "," `t4a_`i'22' "," `t4a_`i'23' "," `t4a_`i'24' "," `t4a_`i'25' "," `t4a_`i'26' "," `t4a_`i'27' "," `t4a_`i'28' "," `t4a_`i'29' "," `t4a_`i'30' "," `t4a_`i'31' "," `t4a_`i'32' "," `t4a_`i'33' "," `t4a_`i'34' "," `t4a_`i'35' "," `t4a_`i'36' "," `t4a_`i'37' "," `t4a_`i'38' ","
}

The results looks likt the following:

0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,1,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,1,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,1,0,0,1,1,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,2,5,18,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,0,5,7,16,13,13,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,3,5,9,16,20,20,2,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,1,1,4,15,17,24,16,10,6,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,1,5,10,18,20,13,5,10,3,0,0,0,0,0,0,0,0,0,0,0,
1,0,0,0,0,0,0,0,2,2,15,14,16,13,9,3,3,5,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,1,1,3,6,14,19,11,4,9,0,2,2,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,1,0,0,1,5,4,10,15,10,3,1,1,1,1,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,1,2,3,6,7,16,18,12,9,5,5,3,1,1,1,0,0,0,0,0,0,0,
0,0,0,0,0,0,1,0,3,8,9,15,13,12,6,4,5,1,1,0,1,1,0,0,0,0,0,0,
0,0,0,0,1,0,0,3,1,10,8,19,14,15,12,5,4,2,0,1,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,2,2,11,5,21,20,11,8,3,3,1,1,0,0,0,0,1,0,0,0,0,
0,0,0,0,0,0,0,1,7,7,8,11,22,9,8,4,1,4,1,2,2,0,2,0,1,0,0,0,
0,0,0,0,0,0,0,3,3,10,16,10,8,7,4,3,2,0,2,1,0,0,0,0,0,0,0,0,
0,0,0,1,0,0,0,3,4,9,3,12,11,8,6,5,2,2,1,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,2,1,3,7,10,7,4,3,3,1,1,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,1,2,6,8,13,8,3,1,2,1,1,1,0,0,0,0,0,0,0,0,1,
0,0,0,0,0,0,0,4,2,4,3,8,5,2,2,3,2,0,0,0,0,1,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,3,8,7,9,4,5,1,2,2,1,0,0,0,0,1,0,0,0,0,0,
0,0,0,0,0,0,1,0,2,2,7,10,3,5,1,2,0,0,0,0,1,0,0,0,0,0,1,0,
0,0,0,0,0,0,0,0,4,1,2,1,4,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,1,1,2,5,3,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,1,0,5,2,2,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,1,3,3,0,3,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,3,3,7,3,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,1,4,4,6,1,6,2,0,3,0,0,0,0,1,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,1,4,7,6,8,7,1,0,0,0,1,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,0,0,3,5,9,12,9,10,7,7,2,0,0,0,0,0,0,0,0,0,0,0,
0,0,0,0,0,0,2,4,6,10,2,7,14,13,7,5,1,0,0,0,1,0,0,0,0,0,0,0,

In the display part, I only use loop structure for the rows but not the columns, which makes the programming a bit complicated to write.

So my question is that is there any way that I can also write a loop structure for the columns to get the same output results as above? How to use more than one loop in the display command so that the program can out put the table that I want?

Thank you very much!

Jackie

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

*
* 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/




© Copyright 1996–2021 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index