I would like to back up a file using something like the mod function in the dataset name. Is there a way to name a file:
data backup_&odd_even;
set test;
run;
I would like to have the backup for a month and every other month have it written over but I do not know how to name the &odd_even variable to be a 1 or a 2 based on the month.
Mark
Use the MOD() function. Easier if you name them 0 and 1.
data backup_%sysfunc(mod(%sysfunc(today(),month.),2));
Use the MOD() function. Easier if you name them 0 and 1.
data backup_%sysfunc(mod(%sysfunc(today(),month.),2));
Awesome, thank you.
Assuming you have the date as a macro variable you could create
%sysfunc(mod(%sysfunc(month(&Date)), 2))
for a 0 , 1 even - odd
or %eval(2 - [the expression above]) to have 1, 2 with 1 odd , 2 even
Richard
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.