Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

# Re: st: RE: extract the value from one cell and past it in another cell (Out of Office Autoreply: sarah.miller@lshtm.ac.uk)

 From To Subject Re: st: RE: extract the value from one cell and past it in another cell (Out of Office Autoreply: sarah.miller@lshtm.ac.uk) Date Fri, 21 Dec 2012 01:44:32 +0000

```I am out of the office until Tuesday 8th January 2012.  I shall deal with your enquiry upon my return.  Enjoy the festive season!

Sarah Miller
------------------------------------------------------
Department of Medical Statistics
London School of Hygiene & Tropical Medicine
Keppel Street
London
WC1E 7HT
http://pathways.lshtm.ac.uk

>>> "Sarah Edgington" <sedging@ucla.edu> 12/21/12 01:42 >>>

I think you've simplified your example too far for it to be clear what you actually want to do.
Under what circumstances do you want to make the substitution?  I could make some guesses based on your example, but they'd be nothing more than guesses.
If you can explain what rules you want to use to decide what cell to extract values from and which cells to copy those values to, we can probably help you figure out how to write the code.
-Sarah

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Lingxiang Li
Sent: Thursday, December 20, 2012 5:04 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: extract the value from one cell and past it in another cell

I am new to Stata and sorry if this problem seems to be too simple. I did my search online but failed to find any useful information.

I want to extract the value of one observation from a string variable and past it in another cell. (sounds like a Excel manipulation. Anyway, hope you get what I mean)

Var1 (string variable)       Var2
1.    a                                       x
2.    ab
3.    abc                                    z

how do I extract ?abc? from var1?s 3rd observation and past into the second observation of var2. so I want it to look like the following graph after the command

Var1 (string variable) Var2
1. a                                 x
2. ab                              abc
3. abc                             z

Question: what is the command? (since I want to do this many times in a loop fashion, so I cannot manually type: replace var2=?abc? if _n==2)

Thank you very much.

Billy Li

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/
```