read a macrovariable which has a date value.

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

read a macrovariable which has a date value.


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.


Accepted Solutions
Solution
‎05-15-2014 05:15 PM
Super User
Posts: 10,548

Re: read a macrovariable which has a date value.

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.

View solution in original post


All Replies
Solution
‎05-15-2014 05:15 PM
Super User
Posts: 10,548

Re: read a macrovariable which has a date value.

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.

Occasional Contributor
Posts: 14

Re: read a macrovariable which has a date value.

thanks mate, it worked

Cheers!!!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 149 views
  • 0 likes
  • 2 in conversation