RE: st: creating a variable equal to the last number of another

["Oliinik, Victoria" <Victoria.Oliinik@econ.kuleuven.be>]

Hi guys, 

My problem is similar to Maria's, but from your command I cannot figure out how to apply it to my case.

Basically I just need to keep the first 2 digits of my variable "code".
Variable code has from 2 to 4 digits, but it is only the first 2 that I need to keep in order to sort companies for which I have US SIC codes 
Into sectors 

"agriculture" (codes whose first 2 digits range from 01 to 09)
"mining" (codes whose first 2 digits range from 10 to 19)
"manufacturing" (codes whose first 2 digits range from 20 to 39)
"services (codes whose first 2 digits range from 40 to 99)


(as shown on  http://www.census.gov/epcd/naics02/S87TON02.HTM - click on more)

Can you give me an idea on how to structure my command?

Many thanks in advance, 

Victoria


 
-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Mar�a Paula Cacault
Sent: vrijdag 16 november 2007 14:50
To: 'statalist@hsphsun2.harvard.edu'
Subject: RE: st: creating a variable equal to the last number of another

Thank you very much to Michael, Phillip and Richard!
Both commands worked equally well.

Cheers,

Mar�a Paula Cacault
Asistente de Investigaci�n
Fundaci�n de Investigaciones Econ�micas Latinoamericanas
Buenos Aires, Argentina
Tel: +54 11 4314 1990 (int. 514)


-----Mensaje original-----
De: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]En nombre de Richard
Goldstein
Enviado el: Viernes, 16 de Noviembre de 2007 10:42 a.m.
Para: statalist@hsphsun2.harvard.edu
Asunto: Re: st: creating a variable equal to the last number of another


The solution below makes a number of assumptions; here is a more general 
one:
. sysuse auto
. gen prend=real(substr(string(price),-1,.))

Rich

Michael Foster wrote:
> good morning,
> 
> here's what I'd do -- the original variable is -occ-
> 
>    gen lastdigit=occ-int(occ/10)*10
> 
> that should work--
> michael
> 
> UNC School of Public Health
> 
> 
> 
> Mar�a Paula Cacault wrote:
>> Dear listers:
>> I have a variable (occupational code) that takes values 1 to 10000 but
>> always finishes in 1, 2, 3 or 4 (qualification level). I need to create a
>> new variable with this last numbers (qualification level) so my new 
>> variable
>> takes values 1 2 3 and 4 (the original variable has no puncts or commas
>> separating the figures).
>> Is there a way to do it?
>> Thank you very much
*
*   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/

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

Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm


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