topic Re: sysfunc to convert SAS date does not work in SAS Programming

sysfunc to convert SAS date does not work

Billybob73 — Thu, 08 Mar 2018 14:33:38 GMT

Hi,

I'd like to convert the macro variable sasdate to date9. format, but I can't get this to work.

I get the message below and i don't know what this message means.

Anyone ?

Thanks very much !

21 %let sasdate=%sysfunc(intnx(year,%sysfunc(today()),0));
22 %let otherdate = %sysfunc(INPUTN(&sasdate., YYMMDD8.), date9.);
WARNING: Argument 1 to function INPUTN referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range.

Re: sysfunc to convert SAS date does not work

LinusH — Thu, 08 Mar 2018 14:44:04 GMT

Why don't you use the correct format in the first %sysfunc call?

Not sure why you need all this logic, why not

%let otherdate = 01Jan%substr(&sysdate9,6,4);

untested...

Re: sysfunc to convert SAS date does not work

RW9 — Thu, 08 Mar 2018 15:00:18 GMT

Why? As:

%put %sysfunc(today(),date9.);

You only need to specify the format in the call...

Re: sysfunc to convert SAS date does not work

Kurt_Bremser — Thu, 08 Mar 2018 15:19:41 GMT

As soon as I see two or more %sysfunc's in a single line of code, I go data step:

data _null_;
sasdate = intnx('year',today(),0,'b');
call symput('otherdate',put(sasdate,date9.));
run;

Re: sysfunc to convert SAS date does not work

Tom — Thu, 08 Mar 2018 15:18:49 GMT

Your first step is generating a raw date value. The number of days since 1/1/1960.

So the second step needs to use the PUTN() function to apply a format.

%let otherdate = %sysfunc(PUTN(&sasdate., date9.));

Or you could generate the value using YYMMDDn8. format to begin with.

%let sasdate=%sysfunc(intnx(year,%sysfunc(today()),0),yymmddn8);

Then your INPUTN() function call should work.