Statalist The Stata Listserver


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

st: RE: repeating strings


From   "Scott Merryman" <smerryman@kc.rr.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: repeating strings
Date   Tue, 17 Oct 2006 22:14:23 -0500

I believe this will work:

foreach var of varlist city* {
	qui bysort name (`var'): replace `var' = `var'[_N]
}

Scott


> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of MA V
> Sent: Tuesday, October 17, 2006 9:08 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: repeating strings
> 
> Hello,
> I believe that there is an easy answer for my problem but I can't seem to
> find it anywhere...
> I have a table with the following format (this is a toy example where we
> have the cities in which each person has lived - city1 is where each
> person
> lived first):
> 
> name city1 city2 city3
> John  SF       .     .
> John     .     Chi     .
> John     .      .      LA
> Mary      .      NY    .
> Mary   Chi       .     .
> ...
> 
> What I would like to do is to fill in the missing values with the city
> strings, i.e. I would like to get at the end:
> 
> name city1 city2 city3
> John   SF     Chi    LA
> John   SF     Chi     LA
> John   SF      Chi    LA
> Mary   Chi      NY    .
> Mary   Chi      NY     .
> ...
> 


*
*   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