Posting date = today and value date in the future

[VALLY]

Good day Gurus, 

please assist , am trying to get a Posting date = today and value date in the future

data view;
set work.view2
CPR_CREATE = intnx ('week',today(),-2;
TB_POSTDAT = today() -14;
;
run;

[ed_sas_member]

Hi @VALLY 

Could you please clarify what are the expected results?

[ballardw]

---

@VALLY wrote:

Good day Gurus, 

please assist , am trying to get a Posting date = today and value date in the future

data view;
set work.view2
CPR_CREATE = intnx ('week',today(),-2;
TB_POSTDAT = today() -14;
;
run;

---

Your intnx function call is missing a closing ). and should be throwing syntax errors in the log.

I don't see anything about the future in the above code. So Is the "value date in the future" variable supposed to be CPR_CREATE? Or something else? How far into the future? Currently it looks like you are looking for something 2 weeks in the past.

If TB_POSTDAT is supposed to be your "posting date = today" then why do you subtract 14? Or again is that the desired variable.

Variablename = today();

would create variable with the value of today.

You likely should assign a format such as DATE9. or similar so human eyes have a clue what the value is instead of the 5 digit integer you will get. Today, being 9 March 2020 will have a value of 21983 as the default format will be BEST12.

data example;
   x=today();
   format x date9.;
run;