read a macrovariable which has a date value.

[dennis_oz]

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 · Accepted solution]

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]

thanks mate, it worked

Cheers!!!