Post the full code you're trying to use, include the macro declarations. We don't know how you're defining them or what they look like
Hi Reeza,
Sure...
* flat file data path;
%global fpath;
%let fpath = /data/DEVELOPMENT/LANDING/IN_FILES;
* archive file data path;
%global apath;
%let apath = /data/DEVELOPMENT/LANDING/ARCHIVED_IN;
Moving Flat Files:
This is working:
x "mv /data/DEVELOPMENT/LANDING/IN_FILES/ET002A.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN";
What i need is :
x "mv &fpath/ET002A.D&tdate..EDLY.TXT &apath";
tdate is not defined anywhere.
@SAS_INFO wrote:
Hi Reeza,
Sure...
* flat file data path;
%global fpath;
%let fpath = /data/DEVELOPMENT/LANDING/IN_FILES;
* archive file data path;
%global apath;
%let apath = /data/DEVELOPMENT/LANDING/ARCHIVED_IN;
Moving Flat Files:
This is working:
x "mv /data/DEVELOPMENT/LANDING/IN_FILES/ET002A.D170605.EDLY.TXT /data/DEVELOPMENT/LANDING/ARCHIVED_IN";
What i need is :
x "mv &fpath/ET002A.D&tdate..EDLY.TXT &apath";
/*hi @SAS_INFO
the macro variables are resolved within the _NUll_ data step, so try this */
* flat file data path;
%global fpath;
%let fpath = /data/DEVELOPMENT/LANDING/IN_FILES;
* archive file data path;
%global apath;
%let apath = /data/DEVELOPMENT/LANDING/ARCHIVED_IN;
%let tdate = %sysfunc(today(), yymmdd6.);
%put &tdate;
data _NULL_;
infile "move &fpath./ET002A.D&tdate..EDLY.TXT &apath." pipe;
input;
put _infile_;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.