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.
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.
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.
thanks mate, it worked
Cheers!!!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: