Re: st: Replace string values

[Ronnie Babigumira <rb.glists@gmail.com>]

I thought about this as well, however, it is not always the case that the quarter will take on all the values 1/4 so I 
wanted a solution independent of what values quarter takes on

Thanks nonetheless

Johannes Geyer wrote:

> try to do this: 
> bysort  table  quarter: replace  table = "" if quarter != 1
>
> johannes
>
> *****************
>
> 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/
*
*   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/