topic LIBNAME and CASLIB statements failing with ERROR in LIBNAME stmt and user param is invalid errors in New SAS User

LIBNAME and CASLIB statements failing with ERROR in LIBNAME stmt and user param is invalid errors

thebugslayer — Fri, 10 Jul 2020 16:27:19 GMT

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

76 libname seacoastlib odbc dsn="seacoast" user="myuser" pass="mypassword";

ERROR: seacoastlib is not a valid SAS name.

ERROR: Error in the LIBNAME statement.

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Running the statement below to connect to a SQL Server database through DSN and I get error "ERROR: seacoastlib is not a valid SAS name:

libname seacoastlib odbc dsn="seacoast" user="myuser" pass="mypassword";

I have another statement, almost the same, to a different DSN, all in the same ODBC.INI file; the only difference is that the other statement includes a schema.

libname etllib odbc dsn="etl" user="myuser" pass="mypassword" schema="myschema";

PS: this statement that executes resides in a file created a long time ago. Maybe some variable created that reside in the system somewhere. The one that fails was created today.

I have even tried

caslib seacoastlib datasource="seacoast" user="myuser" pass="mypassword"

What am I missing?

Re: LIBNAME and CASLIB statements failing with ERROR in LIBNAME stmt and user param is invalid error

ballardw — Fri, 10 Jul 2020 16:37:51 GMT

SAS Library names are limited to 8 characters;

seacoastlib is 11 characters

make it shorter

seacoast would be acceptable.

Re: LIBNAME and CASLIB statements failing with ERROR in LIBNAME stmt and user param is invalid error

thebugslayer — Fri, 10 Jul 2020 18:30:22 GMT

Thank you so much!
SAS should take care not to use non-compliant names in online examples.

Re: LIBNAME and CASLIB statements failing with ERROR in LIBNAME stmt and user param is invalid error

ballardw — Fri, 10 Jul 2020 19:51:55 GMT

Please post the link to the online example you reference that used a non-compliant name.