- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
We have SAS EG on Windows and our server is on Linux.
I am trying to write data using this script to QAANAL which is alias libname to a Snowflake library.
PROC SQL inobs=10;
CREATE TABLE QAANAL._JMG_TST AS
SELECT *
FROM dsn._ids
;QUIT;
The following error message results.
ERROR: You cannot create or delete datasets, views or indexes in this mode. Try the option METAOUT=DATA. Use Proc
Metalib to create metadata for datasets.
Google teels me to specify METAOUT=DATA when defining the Snowflake library using the LIBNAME statement, but library is auto assigned so I don't need to create a libname statement. Is a new libname statement needed? I tried composing one using the suggested format below but this produced errors.
libname mylib snowflake dsn='your_dsn' schema='your_schema' METAOUT=DATA;
Any suggestions on how I can successfully write from my SAS environment to Snowflake is greatly appreciated!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
This issue has been resolved. An attribute needed to be added in SAS Management Console.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Note - we are licensed for SAS/ACCESS Interface to ODBC
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
This issue has been resolved. An attribute needed to be added in SAS Management Console.