topic Re: Macro to import a daily csv file in SAS Programming

Macro to import a daily csv file

Timbim — Mon, 31 Jul 2017 06:44:01 GMT

Hi All,

I am faily new to Macro and been a SAS user but not indepth.

I want to automate a step to import a daily CSV file into SAS.

How could I write a macro or sas step to import the file with today's date?

Greatly appreciate your help.

Thanks,

Maggie

Re: Macro to import a daily csv file

Kurt_Bremser — Mon, 31 Jul 2017 06:57:41 GMT

You can create a macro variable that contains today's date in a proper format:

%let today=%sysfunc(today(),yymmdd10.);
%put &today;

If the date is part of the filename, you can then build the filename with the use of the macro variable.

Re: Macro to import a daily csv file

RW9 — Mon, 31 Jul 2017 08:23:49 GMT

The search bar can be used to find topics similar to what you are looking for, this kind of question gets asked at least once a week. In this case, you would need to provide more information such as - what is happening to the file before its gets to SAS, i.e. where is the file stored, is it overwriting a previous file (i.e. same name), or does it have differing names. Is the data cumulative? Is teh data exactly the same structurally? It could just be as simple as having a program run daily which does this:

data in_data;
  infile "<path to files>/The_data_file_%sysfunc(today(),date9.).csv" dlm=",";
  input a $ b $;
run;

proc append base=master data=in_data;
run;