Prev: Sum two values in a column
Next: Compiled Secure Macro on Unix SAS 9.2
From: Kim Brown on 14 Jan 2010 19:18
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
 | 
Pages: 1
Prev: Sum two values in a column
Next: Compiled Secure Macro on Unix SAS 9.2