Dear list,
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]
*
* 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/