Ronnie Babigumira wrote:
I am trying to produce a report using Stata's -list- command. The data looks
like this
table quarter n
qtr_a.dta 1 128
qtr_a.dta 2 129
qtr_a.dta 3 128
qtr_a.dta 4 4
qtr_b.dta 1 130
qtr_b.dta 2 129
qtr_b.dta 3 130
qtr_b.dta 4 5
However, to make it easier on the readers eye (I think), I would list it
like this
table quarter n
qtr_a.dta 1 128
2 129
3 128
4 4
qtr_b.dta 1 130
2 129
3 130
4 5
Any ideas how I can replace the non-first cases of each table with missing
So far, I was trying to go down this path
bysort table quarter: replace table = "" if table ! = table[1]
--------------------------------------------------------------------------------
You were almost there.
Joseph Coveney
. clear *
. set more off
. input str20 table byte quarter int n
table quarter n
1. qtr_a.dta 1 128
2. qtr_a.dta 2 129
3. qtr_a.dta 3 128
4. qtr_a.dta 4 4
5. qtr_b.dta 1 130
6. qtr_b.dta 2 129
7. qtr_b.dta 3 130
8. qtr_b.dta 4 5
9. end
. bysort table (quarter): replace table = "" if _n > 1
(6 real changes made)
. list, noobs sep(0)
+---------------------------+
| table quarter n |
|---------------------------|
| qtr_a.dta 1 128 |
| 2 129 |
| 3 128 |
| 4 4 |
| qtr_b.dta 1 130 |
| 2 129 |
| 3 130 |
| 4 5 |
+---------------------------+
. exit
end of do-file
*
* 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/
