st: ouput tables using command 'display'

["Hui Wang" <jackie_stata@hotmail.com>]

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/