@Schalk_Burger wrote: Thanks! This helped immensely with debugging. Was setting a variable to SQL script and used EXEC() to execute but kept getting errors when using SAS Explicit Passthrough. When I set this, I could see that the SQL script assigned to the variables had missing spaces due to SAS not parsing ENTER as a space. This really helped me immensely. Not sure what that means. Did you perhaps have lines like this in the code: 'this is some long quoted string that is too long for one line of code' You should clean up the code (whether or not you push it to Teradata via SAS) to not have single quoted strings that span lines. 'this is some long quoted string' ||' that is too long for one line' ||' of code' ... View more

Thank Tom, I didn't know it would be that simple.   Is there a way to limit obs out so I can test it? FIRSTOBS / OBS are not suitable as it reads it as one line in.   I am unfamilar with this part of the data step. I have tried a small loop, but does the input hit the PVD as one iteration?   data want; infile oneline dsd dlm=',' recfm=n; n=0; do until (N>=5); input var1-var37 $; N+1; end; run; ... View more