Posting date = today and value date in the future

VALLY — Sun, 08 Mar 2020 10:47:56 GMT

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;

Re: Posting date = today and value date in the future

ed_sas_member — Sun, 08 Mar 2020 10:56:21 GMT

Hi @VALLY

Could you please clarify what are the expected results?

Re: Posting date = today and value date in the future

ballardw — Mon, 09 Mar 2020 19:48:57 GMT

@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;

topic Re: Posting date = today and value date in the future in New SAS User

Posting date = today and value date in the future

Re: Posting date = today and value date in the future

Re: Posting date = today and value date in the future