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! ... View more

I use SAS Enterprise Guide 8.3, with Linux server and Windows SAS EG client.  We recently moved from Netezza to Snowflake/Azure.  This program expands the membership date spans into member months and has worked after we moved to the cloud however 2 months later (no changes to data) the program churns and I have to kill it.  Does Snowflake not like the syntax for the do while program? Any ideas why this did work after move to Snowflake and now 1 month later it churns? SAMPLE DATA data member_spans; infile datalines delimiter= ','; input patient_id $ startElig:date9. endElig:date9. transfer; format startElig endElig date9. transfer dollar12.2; datalines; P12345678,01JAN2023,31OCT2023, 4000 Q23456789,01JAN2023,30JUN2023,461.43 R34567891,01JAN2023,31MAR2023,544.07 S45678912,01JAN2023,31AUG2023,3678.69 S45678912,01SEP2023,31OCT2023,923.46 T56789123,01OCT2023,31OCT2023,18930 U67891234,01JAN2023,31MAR2023,-1269.85 U67891234,01APR2023,31OCT2023,-3019.41 V78912345,01JAN2023,18JUL2023,-3196.49 V78912345,19JUL2023,14OCT2023,-1413.52 V78912345,15OCT2023,31OCT2023,-273.07 run; /*Expand into mms*/ data expand_2_mms; set Member_Spans ; by patient_id startElig endElig ; counter=1; if transfer ne .; do while(startElig <= endElig); output; startElig=intnx('month',startElig,1); counter=counter+1; if startElig >= endElig then leave; end; format startElig date9.; run; ... View more

We are moving off Netezza to Snowflake and have discovered that SAS handles BIGINT formats <= 15 and truncates anything >15.  Is there a way to capture BIGINT values >15 without casting to character?   ... View more