topic Re: Put function output appearing as period (to use in MODZ function) in New SAS User

Put function output appearing as period (to use in MODZ function)

aazzarello — Fri, 06 Jan 2023 15:44:48 GMT

I'm trying to write a piece of code that will send an email out every 3 days. To do that, I'm defining a variable for today which subtracts from an anchored date (Oct 1st, 2022) which is also a variable to give me a calculated number. Then, I'll use the MODZ function and if the output of the modz function is 0, then I will send an email.

However, I'm getting stuck just before the modz function because although I am able to define my variables, I can't view them. The put function shows a "." in the output. This is also the case for the result of the modz function. My IF statement is then getting a "Expecting an arithmetic operator" error which may be because there is no number stored in the variable.

How can I get my put and modz function to output my calculation and variables instead of a period?

This is the code I've been using. The part I'm focusing on right now is bolded:

data p1;
k=today();
r=22101;
p=k-r;
;run;

data e1;
put r;
e=modz(p,3);
;run;

data send;
if(
e=0 then
put "send";
else
put "do not send"
;run;

Re: Put function output appearing as period (to use in MODZ function)

PaigeMiller — Fri, 06 Jan 2023 16:10:01 GMT

There are a number of errors in your DATA SEND code.

There is no SET statement, so the variables in SEND are always missing. Plus other errors. And so this really has nothing to do with MODZ causing errors.

I would simplify your code like this:

data _null_;
    /* Update: Ballardw points out the 22101 is not really the date wanted */
    /* p=today()-22101; */
    /* So the fix is below */
    p=today()-'01OCT2022'd;
    e=mod(p,3);
    if e=0 then put "send";
    else put "do not send;
run;

Re: Put function output appearing as period (to use in MODZ function)

ballardw — Fri, 06 Jan 2023 16:01:14 GMT

You have not told this step that you want to use the data entered:

Instead of

data e1;
put r;
e=modz(p,3);
;run;

I think that you want

data e1;
   set p1;
   put r;
   e=modz(p,3);
run;

The SET statement is one of the statements to bring other data into the current data step code.

You have a similar problem here with no data source:

data send;
if(
e=0 then
put "send";
else
put "do not send"
;run;

Big problem: the numeric value 22101 you are using does not correspond to the date of 1 Oct 2022. It is actually 05JUL2020 when used with date functions. So your result would not be correct.
When you want to specify a date value then you use a date literal such as r ='01OCT2022'd; The form of the text must be in one of the formats the DATE format uses. Strongly recommend using a 4-digit year so there is never any question. The quotes, can be single or double, and the letter D immediately following tell SAS to use the value as an internal date. Also this way it is easy for a human to know the actual date intended. Five-digit dates like 22101 are most likely interpreted as Julian dates (year followed by day sequence in year) and 22101 would be mid-April. Even if you had included the leading zero for day, such as 221001, that essentially random string of digits could be 22 Oct 2001 (or 1901 depending on system settings).

So use the date literal construct.

There are similar constructs for time and datetime values.