Hello All, I have a CSV file contains these data, the first column is a path to a file: "D:\SAS\testfile.txt","Windows" "HOST.ABC.COBOL(FILE1)","Mainframe" I have SAS code to read the CSV file and check the first column to see if the the file exist, even though the CSV file has 2 records, I only see 1 output in the log, and the output always 0. data work.input;
length DataSet $ 50 System $ 50;
infile 'D:\SAS\inputdata.csv' end=eof dlm=',' dsd firstobs=2 truncover;
do while (not eof);
input DataSet $ MALCode $ System $;
%let dsid = %sysfunc(fileexist(DataSet));
%put &dsid;
end;
run; In the end, if the file exist, then I want to keep the record read from CSV file, else then don't keep the record. Hope someone can help point me to the right direction. thank you Mike
... View more