topic looping with a macro in SAS Programming https://communities.sas.com/t5/SAS-Programming/looping-with-a-macro/m-p/50967#M10684 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>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 - <SPAN style="font-size: 10pt; font-family: Courier New;"> </SPAN></P><P></P><P>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.</P><P></P><P>Any help you can offer will be appreciated. </P><P></P><P>Thanks</P><P></P><P>3.8462557E12. The rows where the nikey value does not show up as an exponential, I get results for.&nbsp; </P></BODY></HTML> Fri, 30 Mar 2012 20:01:38 GMT dan999 2012-03-30T20:01:38Z looping with a macro https://communities.sas.com/t5/SAS-Programming/looping-with-a-macro/m-p/50967#M10684 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>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 - <SPAN style="font-size: 10pt; font-family: Courier New;"> </SPAN></P><P></P><P>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.</P><P></P><P>Any help you can offer will be appreciated. </P><P></P><P>Thanks</P><P></P><P>3.8462557E12. The rows where the nikey value does not show up as an exponential, I get results for.&nbsp; </P></BODY></HTML> Fri, 30 Mar 2012 20:01:38 GMT https://communities.sas.com/t5/SAS-Programming/looping-with-a-macro/m-p/50967#M10684 dan999 2012-03-30T20:01:38Z