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!
This issue has been resolved. An attribute needed to be added in SAS Management Console.
Note - we are licensed for SAS/ACCESS Interface to ODBC
This issue has been resolved. An attribute needed to be added in SAS Management Console.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.