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!!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.