Date:         Mon, 28 Jan 2008 09:55:52 -0600
Reply-To:     "Oliver, Richard" <roliver@spss.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Oliver, Richard" <roliver@spss.com>
Subject:      Re: Number order
Comments: To: "Byrd Sellers, Johnita" <Johnita.ByrdSellers@va.gov>
In-Reply-To:  A<D118F582AEBD8C49B05804BA50CD1DA610ECDBB2@VHAV07MSG1.v07.med.va.gov>
Content-Type: text/plain; charset="us-ascii"

Here's one way (assuming ASID is numeric, not string):

compute new_asid=mod(asid,10000)*10000
 + trunc(asid/10000).

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of Byrd Sellers, Johnita
Sent: Monday, January 28, 2008 9:29 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Number order

Hello,



I am currently working on a project where there is something called an
ASID.  The ASID consists of eight numbers.  For example, 11088284 where
11 represents the month, 08 represents the day and 8284 represents the
patient ID.  Now, for each patient ID there are at most 6 entries
corresponding to the different times that data was collected.  I need to
transform the sequence of these numbers so that the ASID looks like
this, 82841108.  In other words, I would need to have the patient ID in
the front so that I would be able to cluster all of the patient IDs
together so that a repeated measures analysis can be done for each
patient.  Is there a way for SPSS to do this?  There are about 3,000
patients so it will be very time consuming, not to mention a lot of
potential errors can occur, if this had to be done by hand.  Thanks in
advance for any assistance that can be given.



Johnita

=======
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