topic INTNX function in loop code in SAS Programming

INTNX function in loop code

AleksandraGav — Thu, 06 Aug 2020 22:53:57 GMT

Hello,

I am trying to use an INTNX function in my loop code but it doesn't accept reference to a field in my table. What can I replace the injury date with if i want to reference this specific date that is different on each row?

e.g.

%monthly_query1 ((INTNX('month',t1.Injury_Dte,0,'e')))
%monthly_query2 ((INTNX('month',t1.Injury_Dte,1,'e')))
%monthly_query2 ((INTNX('month',t1.Injury_Dte,2,'e')))
%monthly_query2 ((INTNX('month',t1.Injury_Dte,3,'e')))
%monthly_query2 ((INTNX('month',t1.Injury_Dte,4,'e')))
%monthly_query2 ((INTNX('month',t1.Injury_Dte,5,'e')))

Re: INTNX function in loop code

Reeza — Thu, 06 Aug 2020 23:00:11 GMT

You need to provide more details.
Starting with the actual macro and how the parameter is being used. You may want to look at CALL EXECUTE and use a loop within a data step if you want to call the same macro multiple times.

Re: INTNX function in loop code

ballardw — Thu, 06 Aug 2020 23:02:52 GMT

Commas are the delimiters of parameters in macros. So the code you show the first comma is ending the parameter. I suspect that you may get errors related to more parameters than defined.

You likely need to quote the value that you want inside %str(<entirevalue goes here>) .

With t1. garbage I assume you are using this to write some SQL code.

You might consider using a data step where you can use a DO loop and an array to hold the values.