looping with a macro

[dan999]

I'm trying to loop through a dataset and return rows based on a proc sql. The DLinMacro file contains the code that I found on this site and I'm trying to modify it.

The code in the LoopingMacro file is my modification. The code works for some of the rows but not for others. For the rows that it doesn't bring back any results for, the nikey value shows up in the log file (attached) as an exponential -

In the SqlUsingIn file I've included code where I used a subquery to show that I can get values back for all of the rows that way. I'm sorry for so many attachments but I was having trouble pasting into the message.

Any help you can offer will be appreciated.

Thanks

3.8462557E12. The rows where the nikey value does not show up as an exponential, I get results for.