BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
persephone
Fluorite | Level 6

 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!

1 ACCEPTED SOLUTION

Accepted Solutions
persephone
Fluorite | Level 6

This issue has been resolved.  An attribute needed to be added in SAS Management Console.

View solution in original post

2 REPLIES 2
persephone
Fluorite | Level 6

Note - we are licensed for SAS/ACCESS Interface to ODBC

persephone
Fluorite | Level 6

This issue has been resolved.  An attribute needed to be added in SAS Management Console.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 545 views
  • 0 likes
  • 1 in conversation