Here is a snapshot of the data I am importing:
james smith" <james_smith@hotmail.com> "a allen" <weshae@aol.com>, "aaron jones" <meismjones@gmail.com>,adam smith ii <adam@gmail.com>
Program I wrote:
data DCAreaMembers;
length FName $10 LName $20 email $40 ;
infile 'v:\orion\mymembers.txt' dlm = '" < > ,';
input FName $ LName $ email $ ;
run;
When I run it, the program pulls the first record only. One issue is that a few of the records show a name suffix. Another issue is that the data shows multiple names and emails on the same row. How can I address both issues. I would not mind combining the suffix with the last name.
james smith" <james_smith@hotmail.com> "a allen" <weshae@aol.com>, "aaron jones" <meismjones@gmail.com>,adam smith ii <adam@gmail.com>
Program I wrote:
data DCAreaMembers;
length FName $10 LName $20 email $40 ;
infile 'v:\orion\mymembers.txt' dlm = '" < > ,';
input FName $ LName $ email $ ;
run;
When I run it, the program pulls the first record only. One issue is that a few of the records show a name suffix. Another issue is that the data shows multiple names and emails on the same row. How can I address both issues. I would not mind combining the suffix with the last name.