Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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


From   Richard Goldstein <[email protected]>
To   [email protected]
Subject   Re: st: creating a variable equal to the last number of another
Date   Fri, 16 Nov 2007 11:53:46 -0500

how about

gen first2=real(substr(string(code),1,2))

Rich

Oliinik, Victoria wrote:
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: [email protected] [mailto:[email protected]] On Behalf Of Mar�a Paula Cacault
Sent: vrijdag 16 november 2007 14:50
To: '[email protected]'
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: [email protected]
[mailto:[email protected]]En nombre de Richard
Goldstein
Enviado el: Viernes, 16 de Noviembre de 2007 10:42 a.m.
Para: [email protected]
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/


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



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index