topic Read CSV file and check file exist in SAS Programming

Read CSV file and check file exist

BladeStorm — Thu, 22 Aug 2024 19:06:47 GMT

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

Re: Read CSV file and check file exist

Kurt_Bremser — Thu, 22 Aug 2024 19:21:54 GMT

%let dsid = %sysfunc(fileexist(DataSet));
%put &dsid;

These are macro statements, which are resolved when the macro triggers are encountered while the code is fetched for compilation. So the FILEEXIST function looks for a file named "Dataset" in the current working directory of the SAS process, which does not exist.

Use data step code:

data work.input;
length DataSet $ 50 System $ 50;
infile 'D:\SAS\inputdata.csv' dlm=',' dsd firstobs=2 truncover;
input DataSet $  MALCode $ System $;	
dsid = fileexist(DataSet);
if dsid;
run;

There is also no need for the DO WHILE, the DATA step loops on itself when it has an INPUT or other statement that reads data.

This also allows use of a Subsetting IF.

Re: Read CSV file and check file exist

BladeStorm — Thu, 22 Aug 2024 19:39:08 GMT

You are amazing Kurt_Bremser, your suggestion works well, thank you so much.