topic Re: Detecting an unknown file in SAS Programming

Detecting an unknown file

bibbnd — Tue, 22 Dec 2020 07:01:36 GMT

I need to find a way to read a group of files automatically in a shared folder. I do not know the file names nor how many at anytime. The file names change all the time.

I would like to create a program that will scan the folder for any files and read them into a dataset.

I was thinking maybe file exist but i am really not sure where to start

Re: Detecting an unknown file

andreas_lds — Tue, 22 Dec 2020 07:46:40 GMT

The steps depend on structure and file-type: if you have text-files with the same structure you can use the infile-statement with wildcard to read all files at once. So what do you have exactly?

Re: Detecting an unknown file

PhilC — Tue, 22 Dec 2020 14:30:59 GMT

Example 12: "Reading All File Members of a Directory" | SAS Help Center: INFILE Statement