About boyandhisrobot

ballardw · ‎10-17-2018

@boyandhisrobot wrote: This was helpful, thank you! I was able to identify that the issue was with the macro variable and not the sql code. Thank you very much! Fixed loop index, I= 1 to 33 may not actually match you created macro variable list of "words" that are found with %scan. Did you find that &variables had fewer than 33 "words"? To make code like that a bit more flexible %do I = 1 %to %sysfunc(countw(&variables.));

boyandhisrobot · ‎10-01-2018

That fixed it, thanks. The problem seemed to be that I wasn't declaring the value first. Thank you.

vishalrajpoot3 · ‎07-19-2018

yes Tom, you are right, it shows only difference. I am at bragging stage of learning SAS, so I just tried to give a part of solution.

Re: Looping inside proc sql with scan function error

Re: Looping inside proc sql with scan function error

Re: Looping inside proc sql with scan function error

Re: Looping inside proc sql with scan function error

Looping inside proc sql with scan function error

Re: How do I set the value of column equal to macro variable contents

How do I set the value of column equal to macro variable contents

Re: Difference between sum(x+y) and sum(x,y)

Difference between sum(x+y) and sum(x,y)

Re: Looping inside proc sql with scan function error

Re: How do I set the value of column equal to macro variable contents

Re: Difference between sum(x+y) and sum(x,y)