DATA Step, Macro, Functions and more

INPUT function reported 'WARNING:

Reply
Super Contributor
Posts: 713

INPUT function reported 'WARNING:

WARNING: INPUT function reported 'WARNING: Illegal first argument to function' while processing WHERE
clause.

 

I want to convert a year to numeric and subset data:

 

data want;

set have;

where input(SUBSTR(trim(Primary_Completion_Date),LENGTH(TRIM(Primary_Completion_Date))-3),best.) >=2015;

run;

Super User
Super User
Posts: 9,599

Re: INPUT function reported 'WARNING:

Please post test data in the form of a datastep!!

 

It takes away the whole guessing part.  What does primary_completion_date look like, is it numeric or character?  If its numeric you don't need any of that:

where year(primary_completion_date) >= 2015;

If its character convert to numeric first:

where year(input(primary_completion_date,yymmdd10.)) >= 2015;
Super Contributor
Posts: 713

Re: INPUT function reported 'WARNING:

the date is charatcter string and I'm getting the year from that string "02/08/2015"

Super User
Super User
Posts: 9,599

Re: INPUT function reported 'WARNING:

So:

where year(input(primary_completion_date,ddmmyy10.)) >= 2015;
Super User
Posts: 10,269

Re: INPUT function reported 'WARNING:

If your date is as you posted, your code has to work:

data test;
primary_completion_date = "02/08/2015";
x1 = input(SUBSTR(trim(Primary_Completion_Date),LENGTH(TRIM(Primary_Completion_Date))-3),best.);
run;

Log from that:

27         data test;
28         primary_completion_date = "02/08/2015";
29         x1 = input(SUBSTR(trim(Primary_Completion_Date),LENGTH(TRIM(Primary_Completion_Date))-3),best.);
30         run;

NOTE: The data set WORK.TEST has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.00 seconds

As you can see, no WARNING.

So I guess your primary_completion_date is not really what you posted. Could it be that it is already a SAS date (numeric with date format)?

Maxim 3: Know your data.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 4 replies
  • 135 views
  • 3 likes
  • 3 in conversation