DATA Step, Macro, Functions and more

Difference in Dates in SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

Difference in Dates in SAS

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;

Accepted Solutions
Solution
‎05-23-2016 01:20 PM
Super User
Posts: 11,343

Re: Difference in Dates in SAS

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.

View solution in original post


All Replies
Solution
‎05-23-2016 01:20 PM
Super User
Posts: 11,343

Re: Difference in Dates in SAS

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.

Occasional Contributor
Posts: 19

Re: Difference in Dates in SAS

That worked! Smiley Happy

Thanks so much for the quick reply.

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 277 views
  • 1 like
  • 2 in conversation