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;
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.
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.
That worked! 🙂
Thanks so much for the quick reply.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.