Statalist


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

st: Replace string values


From   Ronnie Babigumira <[email protected]>
To   [email protected]
Subject   st: Replace string values
Date   Wed, 12 Mar 2008 15:01:42 +0100

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/



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