Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: extract the value from one cell and past it in another cell


From   "Sarah Edgington" <sedging@ucla.edu>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: extract the value from one cell and past it in another cell
Date   Thu, 20 Dec 2012 17:42:47 -0800

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/


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