On a weekly basis, I would like to import Excel files to a remote SAS server using Enterprise Guide 8. Ideally, all I would need to do is put all the files in a local folder, run a program with no manual intervention to finally have the data on the server. These Excel files are coming from different providers and have different challenges to solve: hidden sheets or sheets where the name changes (timestamped-ish). If I use a task, I cannot seem to access the hidden sheets without manual intervention first. The sheets with the changing names will create an error on subsequent runs as the name has changed from the initial configuration. If I use PROC IMPORT, I need to upload the file to the server first and this process doesn't seem to be possible within a program. I'm my mind, I was going to loop an array containing local files names and pass them to PROC IMPORT. Is this possible?
... View more