topic Re: read a macrovariable which has a date value. in SAS Programming

read a macrovariable which has a date value.

dennis_oz — Thu, 15 May 2014 21:07:36 GMT

Hi ,

i have a macro varialbe &file_dt .

it resolves in the log as 2014-05-09.

i want to use this date for computation purposes.

When I try converting it into a numerical sas value like shown below

data test;

T=INPUT(&FILE_DT,YYMMDD10.);

RUN;

T DOES NOT AVE ANY VALUE.

LOG HAS ERROR MESSAGE 'NUMERIC VALUES CONVERTED TO CHARACTER VALUE "

why is this so ?

thanks in advance.

ballardw — Thu, 15 May 2014 21:15:34 GMT

INPUT expects a text value use "&file_dt".

It was doing the arithmetic 2014 minus 05 minus 09, which is why you hade the numeric message.

dennis_oz — Thu, 15 May 2014 22:31:33 GMT

thanks mate, it worked

Cheers!!!