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/
