topic Re: Is there a way to count how many excel files in a file directory in New SAS User

Is there a way to count how many excel files in a file directory

Coding4you — Tue, 27 Jun 2023 14:29:31 GMT

Hi,

I’m trying to set up an output check that counts how many Excel files it has outputted at that particular time. The filename will always have DPSCAIS append, DPSCAIS_interactive, and DPSCAIS_summary. The only differences are the dates and the name at the start. My question is there a way to count how many of these files are outputted in that folder with the file name mentioned? It should always be three files outputted, if it doesn’t have that file name then flag as fail in the output file check.

say the the folder is “ukfh\file\data\outbox”

Thank you

Re: Is there a way to count how many excel files in a file directory

PaigeMiller — Tue, 27 Jun 2023 14:38:43 GMT

There are plenty of discussions here in the SAS Communities which provide instructions on how to read the names of files in a folder. Do a search for this. Use the code provided, then count how many of those files names end with .xlsx (or whatever other filetype you want).

Re: Is there a way to count how many excel files in a file directory

SASKiwi — Wed, 28 Jun 2023 01:08:44 GMT

If these are being produced by a SAS program, I would just check that it ran successfully and then assume that the Excel files were correctly produced. I've usually found that this is a sufficient check.

Even better, schedule this program as a batch job and get it to email you if there is an error of any type, including not producing Excel files. No need to look any further if there is no email. You can assume everything is OK.

Re: Is there a way to count how many excel files in a file directory

Coding4you — Fri, 30 Jun 2023 13:29:34 GMT

Thank you. I managed to get the file to read in. Is there a way to do a loop to check the correct files because the output name will always be different and not dps_bcs ft. The code will not work, but I was thinking something along those line.