topic Re: How to check if a PC file exists without using the FileExists function in SAS Programming

How to check if a PC file exists without using the FileExists function

Michael_W — Thu, 28 Oct 2021 19:04:58 GMT

I am looking for a way to verify that a PC file (e.g. test.csv) exists before I attempt to read it into my process through a data step. The obstacle is that I am not able to use the FILEEXISTS function as the my company has disabled users' ability to use CMD line operations (per corporate policy). I am hoping that someone else has an alternative method to accomplish the same objective.

Thank you in advance for your consideration.

Michael

Re: How to check if a PC file exists without using the FileExists function

SASKiwi — Thu, 28 Oct 2021 19:25:17 GMT

The SAS FEXIST function doesn't require OS command line access.

Re: How to check if a PC file exists without using the FileExists function

Tom — Thu, 28 Oct 2021 21:11:26 GMT

Why would FILEEXISTS() not work because of the NOXCMD option?

It seems to work for me.

1    %put %sysfunc(getoption(xcmd));
NOXCMD
2    %put %sysfunc(fileexist(~/autoexec.sas));
1