seeking help how to compute a new variable - combine 2 values

[thara vardhan-2]

Dear List Members

 I would be grateful if any member could help me combine two variable
values in one column.

For example:

I have two variables   ERefnum  Personcni

                                                  1234    78910

How do I create a new variable with the result as  123478910?

many thanks
Thara Vardhan
Senior Statistician
Performance Improvement & Planning

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

The information contained in this email is intended for the named recipient(s)
only. It may contain private, confidential, copyright or legally privileged
information.  If you are not the intended recipient or you have received this
email by mistake, please reply to the author and delete this email immediately.
You must not copy, print, forward or distribute this email, nor place reliance
on its contents. This email and any attachment have been virus scanned. However,
you are requested to conduct a virus scan as well.  No liability is accepted
for any loss or damage resulting from a computer virus, or resulting from a delay
or defect in transmission of this email or any attached file. This email does not
constitute a representation by the NSW Police Force unless the author is legally
entitled to do so.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Richard Ristow]

At 12:25 AM 12/11/2008, Thara Vardhan wrote:

>I [need to] combine two variable values in one column.
>
>For example: I have two variables
>ERefnum  Personcni
>1234     78910
>
>How do I create a new variable with the result as  123478910?

Untested, but

* If the old variables are both numbers,        ..... .
NUMERIC  Combined  (F10).
COMPUTE  Combined = ERefnum * 1E5
                   + Personcni.


* If the old variables are both strings,        ..... .
STRING   Combined  (A10).

STRING   #Padded   (A5)  /* Personcni w. leading 0s */.

COMPUTE  #Padded  = LPAD(LTRIM(Personcni),5,'0').
COMPUTE  Combined = CONCAT(RTRIM(ERefnum),#Padded).

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD