Date:         Fri, 15 Jan 2010 07:24:40 -0500
Reply-To:     Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Subject:      Re: Moving Character from date
In-Reply-To:  <201001150018.o0EJW5bl023417@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Kim

A little more information would help here. First, what version of SAS are you running. Secondly, your code suggests that the data have been stored as a text file and are no longer in Excel. Is this true? Also, do you have the SAS Access to PC files product?

Nat Wooding

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kim Brown
Sent: Thursday, January 14, 2010 7:18 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Moving Character from date

Hi all,
I have 100 Excel spreadsheets where the last letter of the patient name is
first character of the date field. I'm trying to import all spreadsheets
in SAS and I'm clueless to where to start.

data have;
input lname $ first $ date;
datalines;
kim test 11/22/2008
test ki  m12/28/2009
testy sa  s3/15/2001
run;

Want:

kim test 11/22/2008
test kim  12/28/2009
testy sas  3/15/2001

Any suggestions  is appreciated.
Kim
CONFIDENTIALITY NOTICE:  This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect.  The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized.  If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful.  If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it.  Thank you.