| 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 |
|---|
|
| In-Reply-To: | <95b101340707231210u7399bdb0g921a344832d2bf9c@mail.gmail.com> |
|---|
| 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
name? Always?
You have your work cut out for you.
Ed
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
mailto:EdHeaton@Westat.com http://www.Westat.com
-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of sas biology
Sent: Monday, July 23, 2007 3:10 PM
To: SAS-L@listserv.uga.edu
Subject: Reading from excel
Hi There,
I have an excel file that has the following 5 variables.
Nam_and_Address Speciality Type Protocols
Defaultcenter
The address info is given in multiple lines (records in our language)
within
the EXCEL file. I want to read the data from this file and while doing
so,
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
set
with the following variables.
Name Address Speciality Type Protocols
Defaultcenter
Could somebody help e with this?
| 
