Difference in Dates in SAS

[ashwini2]

If the difference between b.HRA_Unreachable_Date AND TODAY is < 15 then i want to categorize it as "1-15".

But the statemenet i wrote does not work.

b.HRA_Unreachable_Date  is numeric (Date integer from Jan 1, 1960).

Error:

ERROR: Function INTCK requires a numeric expression as argument 2.

ERROR: Function INTCK requires a numeric expression as argument 3.

ERROR: The following columns were not found in the contributing tables: null

proc sql;

create table timeframes as

select distinct a.medicaid_id

, b.min_transfer_Dt

, b.HRA_Unreachable_Date

 , case when intck('day', "b.HRA_Unreachable_Date", "today()") < "15" then "1-15"

else null end as timeframe

 

from HSD.tbl_unreachables as b inner join HSD.Final_attempts as a on b.medicaid_id= a.medicaid_id

;

quit;

[ballardw · Accepted solution]

First try this
intck('day', b.HRA_Unreachable_Date, today()) < 15

You were not comparing the varible but the text of the name b.HRA etc, also the result of INTNX is numeric so do not compare to a text value "15".

If you still get messages about incompatible types it may mean that your HRA_Unreachable_date variable is not a SAS numeric date value but is character. You should go back further in your process and insure the date variable is a SAS date valued numeric.

[ashwini2]

That worked! 🙂

Thanks so much for the quick reply.