Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

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

From |
"Ben Hoen" <bhoen@lbl.gov> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
st: RE: dropping integers from id variable |

Date |
Mon, 6 Feb 2012 09:41:08 -0500 |

I assume they are not strings, but rather numbers, therefore you could try: . tostring id2, replace . replace id2=subinstr(id2,"0","",.) If they are strings then you could use only the second line. Ben Ben Hoen LBNL Office: 845-758-1896 Cell: 718-812-7589 -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of marcos stata Sent: Monday, February 06, 2012 9:03 AM To: statalist@hsphsun2.harvard.edu Subject: st: dropping integers from id variable Dear Statalisters, I need to merge two datasets. The problem I have is that one the id of the master contains zeros (id2) and the other does not (id1). For example, for one observation I have: id1 = 718258, and id2 710820050008. My basic question is: how can I get rid of the zeros of id2 so that I can do a one-to-one merge using the id variables? Which is the function I need to use? Thanks in advance, Marcos * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/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/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**Re: st: RE: dropping integers from id variable***From:*marcos stata <marcosstata@googlemail.com>

**References**:**st: dropping integers from id variable***From:*marcos stata <marcosstata@googlemail.com>

- Prev by Date:
**[no subject]** - Next by Date:
**Re: st: Solution for Autocorrelation in Lag orders for VAR** - Previous by thread:
**st: dropping integers from id variable** - Next by thread:
**Re: st: RE: dropping integers from id variable** - Index(es):