BookmarkSubscribeRSS Feed
RA_SAS
Calcite | Level 5

Hi,

 

I was successful in creating the libname statement to connect to Snowflake but whenever I try to access a table it is giving an error saying ' ERROR: File MYDBLIB.cars.DATA does not exist.'. Below is the code which I used

 

LIBNAME mydblib snow server="snowflakecomputing.com" warehouse=WH_ALL_L
database=DB_Name schema=SCH_Name user="XXXX" password="XXXX";

 

proc sql outobs=50000;
create table work.test1 as
select * from mydblib.cars;
run;

 

' ERROR: File MYDBLIB.cars.DATA does not exist.'.

 

 

 

1 REPLY 1
SASKiwi
PROC Star

Are you sure there is a table called cars in Snowflake? You can run this to check table names:

proc datasets library = mydblib nolist;
contents data = _all_ nods ;
run;

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

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
  • 1 reply
  • 670 views
  • 0 likes
  • 2 in conversation