Statalist The Stata Listserver


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

RE: st: RE: ouput tables using command 'display'


From   "Hui Wang" <[email protected]>
To   [email protected]
Subject   RE: st: RE: ouput tables using command 'display'
Date   Mon, 30 Jan 2006 03:42:16 +0000

Hi, Nick,

Can you recommand any other commands which can help me to write the program more efficiently?

Jackie



From: "Nick Cox" <[email protected]>
Reply-To: [email protected]
To: <[email protected]>
Subject: st: RE: ouput tables using command 'display'
Date: Sun, 29 Jan 2006 23:15:45 -0000

You can nest -forval- loops. But your example
shows that you know that already, so I
can't see what's behind this post.

However, a larger question is why you are
doing it this way. Your table problem
does not look very unusual.

Nick
[email protected]

Hui Wang

> 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?
>

*
*   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/
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! http://search.msn.com/

*
* 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–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index