Check file existence with wildcard and import into SAS

[JLin2021]

Hi All,

I need to check whether an input file exists first; and if it exists then I can import into SAS.

But every time the name of input file will change, e.g. testing_01.xlsx, testing_02.xlsx ..., so I can only use wildcard for the filename.

But then fileexist function does not work for wildcard, so I can't use it to test existence.

Is there anyway to do it? Thanks!

[ballardw]

Details.

Are there other XLSX files in the folder? If so, how will you know which one to use?

[ChrisNZ · Accepted solution]

Look at the the very first locked topic. at the top of the page of the programming community.

You'll see how to list files in a directory.

[JLin2021]

Thanks for your idea! I have now imported the the files into dataset