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!!!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.