Date: Wed, 2 Nov 2005 12:01:26 -0800
Reply-To: Kathy Marshall <KMarshall@chp.ca.gov>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Kathy Marshall <KMarshall@chp.ca.gov>
Subject: Transformation Question
Content-Type: text/plain; charset=US-ASCII
I would like to transform a 5-digit variable called "exam" into a 2-digit variable called "year." The third and fourth digits of exam equal the year.
Exam = Year
I have not been successful in getting LPAD or LTRIM to perform this simple transformation. Would you please help me with specific syntax that would accomplish my goal?
Thanks so much.