Thanks - I can open the file in Notepad++ and my pipe-delimited contents look as expected so I think I can safely ignore what the file explorer is interpreting as the filetype. ... View more

@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 you for this, I wasn't aware of that proportional allocation option, saves a few steps of calculating that manually. Also, it seems as adding the additional sorting variables is doing the trick to ensure my seed= value is keeping the sample the same each run. ... View more

Yes.  You would schedule a job to execute SAS itself.     So you might have a line like this to run a SAS program at midnight every night. 0 0 * * * 'cd /myfiles ; sas myprogram.sas'   ... View more

I guess the moral of this long saga is don't totally rely on SAS editor colour coding as it is not entirely foolproof. But I'm sure you knew that anyway... ... View more

Can anyone confirm what hotfix this was fixed in? I am working in Enterprise Guide 7.15 (7.100.5.5850) and I have the same problem except the word 'where' is formatted in red font as an undefined keyword.     ... View more

Thanks for the suggestion. I did something similar to this. Since the tables in my joins that are impacted by the reserved words are very small lookup tables, I just did separate data steps to create temporary datasets in the Work library and used a rename= option to change the variable names. ... View more

Thanks for the references Paul! ... View more