Dear Experts ,
I am in a need of an automation of the file folder path , The exporting file should be taken and placed in the folder and folder name should be todays date ,which should automatically identified . Could any one help on this . I tried with the attached macro but it is not working
%let td_dt=today();
data _NULL;
call symput ('Folder_dt',put(&td_dt, YYMMDDd10.));
run;
%put &Folder_dt;
What "exporting file"? All you have shown is a macro variable creation (from a already existing function!!) and a put. If you want to write to a file with the date in the filename or in the path:
/* Folder */ ods rtf file="c:/temp/%sysfunc(today(),yymmdd10.)/yourfile.rtf"; /* Filename */ ods rtf file="c:/temp/somewhere/file_%sysfunc(today(),yymmdd10.).rtf";
No need to do all the macro parts.
How about this?
data _NULL;
call symput ('Folder_dt',put(today(), YYMMDDd10.));
run;
%put &=folder_dt;
See sample code below. It uses the macro facility to create the foldername. Then a LIBNAME statement together with the DLCREATEDIR system option is used to create the actual folder on the filesystem.
options dlcreatedir;
%let todayFolderName = %sysfunc( today() , yymmddd10.);
libname _cdir "c:\temp\&todayFolderName";
libname _cdir clear;
Depending on your SAS version have a look at the DCREATE function as well.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.