|Date: ||Tue, 24 Jul 2007 17:49:27 -0400|
|Reply-To: ||Ed Heaton <EdHeaton@WESTAT.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Ed Heaton <EdHeaton@WESTAT.COM>|
|Subject: ||Re: Reading from excel|
|Content-Type: ||text/plain; charset="us-ascii"|
This brings to mind my adage - "It's easier to put values together than
to separate them!"
Whoever created your file obviously didn't understand this. What rules
do you want to use to separate the name from the address? Does the name
always precede the address? Which comes first: the surname or the given
You have your work cut out for you.
Edward Heaton, Senior Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1650 Research Boulevard, RW-4541, Rockville, MD 20850-3195
Voice: (301) 610-4818 Fax: (301) 294-3879
From: firstname.lastname@example.org [mailto:email@example.com]
On Behalf Of sas biology
Sent: Monday, July 23, 2007 3:10 PM
Subject: Reading from excel
I have an excel file that has the following 5 variables.
Nam_and_Address Speciality Type Protocols
The address info is given in multiple lines (records in our language)
the EXCEL file. I want to read the data from this file and while doing
want to separate the address and name information into two separate
variables.Thus the new data set will have 6 variables. I want the data
with the following variables.
Name Address Speciality Type Protocols
Could somebody help e with this?