The above code was working locally with the same file? What was exactly the code? Stange, that you can read an Excel file using a data step. What doeas "run local" mean? Do you have SAS installed on your (Windows?) desktop? Or you have only EG (so you were connected to a SAS server)? Is the server Windows? Do you have ACCESS to PC file on the server< If this is real Excel data (not csv), use ftp binary transfer: FILENAME TEST11 FTP 'mydata.xls' lrecl=256 binary                 CD='/EEXInterfaces/Data/'                 HOST='myhost'                 USER='anonymous'                 PASS='XXXX' ; ... View more

Hi:   If you need urgent help, or help "ASAP" then your best resource is to open a track with Tech Support. To open a track with Tech Support, click on any of the links in the forum that say "submit a problem" or send mail to support@sas.com. cynthia ... View more

Hi, this helps you get what you want... Assume that toto is your initial dataset proc sort data=toto out=titi; by id id1 id2 date1 date2 status; run; data tata; set titi; by id id1 id2 date1 date2 status; if last.date1; if status in ('PC', 'DE') then delete; run; BR. ... View more