Re: st: editing of a variable content in stata

["Michael N. Mitchell" <Michael.Norman.Mitchell@gmail.com>]

Greetings

  I would give this a try...

generate firm1 = real(substr(firm,3,3))

  The -substr()- function extracts the substring starting with the third digit, and 
extracting three digits, converting "IF789O" to "789", and then the -real()- function 
converts it into a number.

I hope that helps,

Michael N. Mitchell
Data Management Using Stata      - http://www.stata.com/bookstore/dmus.html
A Visual Guide to Stata Graphics - http://www.stata.com/bookstore/vgsg.html
Stata tidbit of the week         - http://www.MichaelNormanMitchell.com



On 2011-01-28 11.22 AM, rado645-bg@yahoo.de wrote:
> I have a variable that is a code identifier for firms. it contains letters and
> numbers. I would like to remove the first two digits  (these are letters) and
> the last one from each firm identifier. Is this possible in stata?
>
> Ex.
>
> Firm   Code
>
> irm1   If7890
>
> Firm2 Fr5671
>
> Firm3 er4560
>
>
> I would like to have at the end:
> Firm   Code
>
> Firm1  789
>
> Firm2  567
>
> Firm3  456
>
>
>
> *
> *   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/