@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