Statalist


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

Re: st: Replace string values


From   Ronnie Babigumira <rb.glists@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Replace string values
Date   Wed, 12 Mar 2008 16:05:31 +0100

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/



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