topic Re: Check file existence with wildcard and import into SAS in SAS Programming

Check file existence with wildcard and import into SAS

JLin2021 — Wed, 16 Dec 2020 15:39:18 GMT

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 — Wed, 16 Dec 2020 16:09:43 GMT

Details.

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

ChrisNZ — Wed, 16 Dec 2020 22:10:41 GMT

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 — Fri, 18 Dec 2020 05:35:57 GMT

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