Automate import files

Fkoch01 — Fri, 24 Mar 2017 07:14:23 GMT

Good day

I would like to automate Excel files that is stored on a server. This should import the files outomaticly every week. Is this posible and how will I go about to make this work?

The files is updated for each month. Ex

file_2017-03

file_2017-02

...

Regards

Re: Automate import files

Kurt_Bremser — Fri, 24 Mar 2017 07:24:11 GMT

Start with creating SAS code that successfully imports one file.

For consistent results, I would strongly advise to not use the Excel file format, but a textual format like csv and a properly written data step, so that unexpected changes in the input data structure are caught at the earliest possible point of your ETL chain. .xls is crap as a data transfer format.

Then parameterize the infile name:

data _null_;
filedate = put(today(),yymmd7.);
call symputx('filedate',filedate);
run;

filename in "/path/file_&filedate..csv";

topic Automate import files in SAS Enterprise Guide

Automate import files

Re: Automate import files