String Comparision with Like Or use of a SAS Function

[SASKiwi]

I would simplify your query down to something that works then progressively add lines back until it fails. Try starting with something like this:

proc sql;

  SELECT  count(*) as count

  FROM MAP_INPUT AS MI

  INNER JOIN rule_trans3 AS RT

  ON MI.POST_DATE = RT.POST_DATE

;

[ven]

Yes, if I use equal sign it works, problem is need to use like operator.

[SASKiwi]

Please explain why you need to use LIKE.