Perhaps the following:

data in ; infile ........... ; input fmame $ lname $ @ 'A01' date1 mmddyy6. @'A01' date2 mmddyy6. ; run;

> -----Original Message----- > From: Julie Smith [SMTP:jgasmith@UCDAVIS.EDU] > Sent: Tuesday, April 16, 2002 9:00 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Reading data into SAS > > I have some text data I don't know how to get SAS to read or import into > SAS. For each record (person) there is an identifying code then a date > then > a code then a date mixed in with other data I do not want. For example, > two > records may look like this: > > Julie Smith AO1030499 kfjalskdjldskj AO1060899 kldsjfe9823r > George Smith slkdfjsdfk AO1030499 lksdjfslkjfd > > I want SAS to look at the code AO1 then abstract the date after it (ie > 030499) and on the same record look at the same code AO1 and the date > after > that (060899) and ignore the rest of the data. The final result I would > like is something like this: > > Julie Smith 030499 060899 > George Smith 030499 > > Thanks.

**************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************