| |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Creating a new numerical variable without mathematical operations
From |
"liu nizi" <[email protected]> |
To |
[email protected] |
Subject |
Re: st: Creating a new numerical variable without mathematical operations |
Date |
Sun, 22 Oct 2006 07:19:26 +0800 |
Firstly,you can translate these two variables into string variables by
command tostring.
Secondly, you combine these two string variable just by gen
newcity=province_str+city_str
Thirdly, translate newcity into numrical variable by command destring
It does work,you can try it
From: "Ramani Gunatilaka" <[email protected]>
Reply-To: [email protected]
To: [email protected]
Subject: Re: st: Creating a new numerical variable without mathematical
operations
Date: Sat, 21 Oct 2006 15:34:22 +0100
Hi Fredrick and Jeph,
Thanks for your suggestions. My problem is that the city variable
does
not always have four digits. Sometimes it is two, at other times, it
is three.
Thanks anyway.
Best,
Ramani
On 21/10/06, Frederick J. Boehmke <[email protected]> wrote:
If I understand the range of the two variables properly, perhaps:
gen newcity = 10000*province + city
will work?
On Sat, 21 Oct 2006, Ramani Gunatilaka wrote:
> Date: Sat, 21 Oct 2006 14:47:09 +0100
> From: Ramani Gunatilaka <[email protected]>
> Reply-To: [email protected]
> To: [email protected]
> Subject: st: Creating a new numerical variable without
mathematical operations
>
> Dear all,
> I have two numerical variables, province and city: province has
two
> digits, city has at least 4.
> eg. province= 11, city= 6227
> I want to create a new numerical variable called 'newcity' which
will
> combine province and city like this:
> 116227
> This is because I have to combine this data set with another,
and the
> unique identifying variable in the second data set has been
> constructed in this way.
> Can someone please tell me what command I may use?
> Thanks so much,
> Ramani
> *
>
*
* 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/
_________________________________________________________________
�����������ѽ��н�������ʹ�� MSN Messenger: http://messenger.msn.com/cn
*
* 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/