Hello- I have a username that it similar to this: "MY-USER-NAME" and this is causing me issues when it comes to using it as a schema in my libname. I have tried creating a secondary variable that upcases and double quotes the username and passing that in, which allows me to assign the libname just fine, but once I attempt to use it in a data step i receive the below error. User name secondary variable: %let nUser = "%upcase(&user.)"; Then I successfully assign the libname: libname nzp netezza user=&nUser. password="&nzpass" server="server.co.net" database="DBC" schema=&nUser. connection=shared;
NOTE: Libref nzp was successfully assigned as follows:
Engine: NETEZZA However, attempting to create a dataset on Netezza with a data step causes this: data nzp.mytable (bulkload=yes);
set work.have;
run;
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: ERROR: 'USER-NAME.MYTABLE' error ^ found "-" (at
char 0) expecting `AS'.
NOTE: The DATA step has been abnormally terminated. The issue appears to be that when the libname references the schema inside the data step, it is unquoted, thereby causing this error. Also to note, there are tables in Netezza currently that have this username as their schema, they simply show double quotes around the schema name. Thank you in advance for any assistance!
... View more