Date:         Thu, 11 Dec 2008 00:43:07 -0800
Reply-To:     fomcl@yahoo.com
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Albert-jan Roskam <fomcl@yahoo.com>
Subject:      Re: seeking help compute a new variable - combine 2 values
Comments: To: Thara Vardhan <vard1tha@police.nsw.gov.au>
In-Reply-To:  <OF3DD02F37.437B26E8-ONCA25751C.001CD2B9-CA25751C.001D23E8@police.nsw.gov.au>
Content-Type: text/plain; charset=us-ascii

if they're both string variables, use CONCAT:
string combi (a50).
compute combi = concat(refnum, person).

if not, you have to make to scratch string equivalents of the two numerical vars, and concatenate those.

Cheers!!
Albert-Jan


--- On Thu, 12/11/08, Thara Vardhan <vard1tha@police.nsw.gov.au> wrote:

> From: Thara Vardhan <vard1tha@police.nsw.gov.au>
> Subject: seeking help compute a new variable - combine 2 values
> To: SPSSX-L@LISTSERV.UGA.EDU
> Date: Thursday, December 11, 2008, 6:19 AM
> Dear List Members
>
> I would be 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
> LISTSERV@LISTSERV.UGA.EDU (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

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (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