I have to merge these two sets of data, which contains exactly the same data, but written in different ways: Offsite data: * (i);
A123 4Mar1989 8,60000
A037 23Jun1957 21,45000
M015 19Sep1977 17,50000
* (ii);
A123 4Mar1989 8,6,00
***************
A037 23Jun1957 21,450
**************
M015 19Sep1977$17,500
*********** The first record should have ID = "A123", DEPT = "A", BIRTHDAY = 10655, YEAR = 1989, SALARY = 8600 So far my approach has been(which doesn´t work): data i;
input $ID $Dep $BIRTHDAY $YEAR $SALARY;
datalines;
A123 4Mar1989 8,60000
A037 23Jun1957 21,45000
M015 19Sep1977 17,50000
;
run; Any suggestions?
... View more