topic Re: mod function in SAS Programming

mod function

Steelers_In_DC — Sun, 24 Aug 2014 14:19:58 GMT

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

Re: mod function

Tom — Sun, 24 Aug 2014 14:52:50 GMT

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

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

Re: mod function

RichardinOz — Sun, 24 Aug 2014 14:56:13 GMT

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

Re: mod function

Steelers_In_DC — Sun, 24 Aug 2014 15:21:48 GMT

Awesome, thank you.