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?
SAS Library names are limited to 8 characters;
seacoastlib is 11 characters
make it shorter
seacoast would be acceptable.
SAS Library names are limited to 8 characters;
seacoastlib is 11 characters
make it shorter
seacoast would be acceptable.
Please post the link to the online example you reference that used a non-compliant name.
Nearly 200 sessions are now available on demand in the Innovate Hub.
Watch Now →SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.