LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2008)Back to main SPSSX-L pageJoin or leave SPSSX-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SPSSX-L page