Statalist The Stata Listserver


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

st: repeating strings


From   "MA V" <ma_v@hotmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: repeating strings
Date   Wed, 18 Oct 2006 02:08:22 +0000

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

Any suggestions?
Thanks!

_________________________________________________________________
Get today's hot entertainment gossip http://movies.msn.com/movies/hotgossip?icid=T002MSN03A07001

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