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!!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.