DATA Step, Macro, Functions and more

Macro to import a daily csv file

Reply
Occasional Contributor
Posts: 5

Macro to import a daily csv file

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

Super User
Posts: 6,946

Re: Macro to import a daily csv file

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.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Super User
Posts: 7,407

Re: Macro to import a daily csv file

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;
Ask a Question
Discussion stats
  • 2 replies
  • 81 views
  • 0 likes
  • 3 in conversation