mod function

[Steelers_In_DC]

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

[Tom · Accepted solution]

Use the MOD() function.  Easier if you name them 0 and 1.

data backup_%sysfunc(mod(%sysfunc(today(),month.),2));

[Steelers_In_DC]

Awesome, thank you.

[RichardinOz]

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