mod function

Accepted Solution Solved
Reply
Valued Guide
Posts: 858
Accepted Solution

mod function

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



Accepted Solutions
Solution
‎08-24-2014 10:52 AM
Super User
Super User
Posts: 6,845

Re: mod function

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

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

View solution in original post


All Replies
Solution
‎08-24-2014 10:52 AM
Super User
Super User
Posts: 6,845

Re: mod function

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

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

Valued Guide
Posts: 858

Re: mod function

Awesome, thank you.

Super Contributor
Posts: 644

Re: mod function

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 323 views
  • 3 likes
  • 3 in conversation