This is one of the classic SAS errors that you can get from PROC SQL and it can be thrown by a number of things. Missing out a comma in a list of variables on a SELECT statement is one situation that will do it, as will having an extraneous one. As I discovered recently, an ill-defined SAS function nesting like LEFT(TRIM(PERIOD,BEST.)) will have the same effect; notice the missing PUT function in the example. The latter surprised me because I might have expected something more descriptive for this as would be the case in data step code. In the event, it took some looking before the problem hit me because it’s amazing how blind you can become to things that are staring you in the face. Familiarity really can make you pay less attention.
Posted on June 14, 2010 in Programming
- Compressing a VirtualBox VDI file for a Windows guest running on a Linux Host
- Killing Windows processes from the command line
- WARNING: No bars were drawn. This could have been caused by ORDER= on the AXIS statement. You might wish to use the MIDPOINTS= option on the VBAR statement instead.
- Adding GNOME 3 to Linux Mint 11
- /sbin/mount.vboxsf: mounting failed with the error: Protocol error
- Finding the number of observations in SAS dataset