Hi @prashanthi, As @pchegoor1 points out, support for Snowflake Temporary Tables was added to SAS/ACCESS. I retired from SAS before this support was added, so I don't have any example code to share. Best wishes, Jeff ... View more

Hi @SASWayne,  There isn't a difference in use. SASIOSNF is the actual engine name. SNOW is an alias. Both work. Best wishes, Jeff ... View more

Too funny! And just a little true. ... View more

Hi @StephenFoerster, it is great to cross paths with you again. I am doing great and hope you are. I miss working with you. ... View more

Hi @AhmedAl_Attar, That is good to know. Thank you for reading my posts and watching the videos. Is there any content you would like to see on our YouTube Channel?  Hopefully, you have subscribed. We are going to add a lot of content in 2024 (Included more certification  helpers - uh, cheat codes) 🤣 ... View more

Hi @Lenvdb, I no longer work at SAS. You may want to contact SAS Tech Support. ... View more

Hi @AhmedAl_Attar, It has been a while. I hope you are doing well.  I am curious, how did you hear about TiDB? ... View more

Hi,   I did find this in the doc: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n103yhji21l0c8n1iuto084a72q5.htm   Good luck.   Best wishes, Jeff ... View more

Hi, It has been a while (I retired from SAS) so things may have changed (I doubt it), SAS doesn't support connecting to Hadoop (using SAS/ACCESS to Hadoop) from AIX. The problem is that the Hadoop community doesn't support AIX. So, there was no way for SAS to suppport it.  Make sure to ask this specific question: Is SAS/ACCESS Interface to Hadoop supported on AIX?   Best wishes, Jeff ... View more

Hey, ChatGPT can answer this... ... View more

Hi @awbadam    SAS/ACCESS Interface to Snowflake works with both SAS Viya and SAS 9.4.  The differences between the Snowflake product and generic ODBC product are discussed in this paper. https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4103-2020.pdf Best wishes, Jeff ... View more

Hi @Charoon_c, I am no longer with SAS. I only had my account restored a few months ago.  Best wishes, Jeff  ... View more

Hi @pchegoor1    I have requested the feature. Hopefully, it will be released soon.   Best wishes, Jeff ... View more

Hi @pchegoor1    I am no longer a Product Manager, so I don't keep up with these things like I used to. That being said, I think TEMP TABLES are a recent addition to Snowflake.   SAS/ACCESS Interface to Snowflake doesn't support TEMP TABLES. I will create a feature request and see if I can have this capability added to the roadmap.    Best wishes, Jeff ... View more

Hi @techie    In order for a SAS function to be passed down to a database it must be passed down to the database. The following SAS statement will display the SQL that is sending to the database:   OPTIONS SASTRACE=',,,d' SASTRACELOC=SASLOG NOSTSUFFIX;   You can see an example of it in this SGF workshop I delivered. It is old, but most of it is still relevant. https://github.com/Jeff-Bailey/SGF2016_SAS3880_Insiders_Guide_Hadoop_HOW   Best wishes, Jeff ... View more