In April 2016, the SAS/ACCESS family of products grew by a new member: SAS/ACCESS Interface to Amazon Redshift.
While you could (and still can) use SAS/ACCESS to ODBC to access Amazon Redshift data from your SAS jobs and applications, the new engine brings a series of enhancements over that route.
- Enhanced implicit pass-through (implicit conversion of SAS queries into Amazon Redshift SQL). Implicit pass-through is turned on by default (DBIDIRECTEXEC option) to minimize the amount of data transferred to SAS.
- More SAS functions will push down to the database.
- Explicit pass-through support (you can create and execute Amazon Redshift code from SAS).
- Better data insert performance.
Note that SAS/ACCESS Interface to Amazon Redshift requires the 3rd Maintenance release of SAS 9.4.
"This sounds good; where do I learn more?", you wonder. There is a recently published whitepaper that provides much more granular info and code examples: It’s raining data! Harnessing the Cloud with Amazon Redshift and SAS/ACCESS, by Chris DeHart and Jeff Bailey.
You might also want to check out the SAS Tech Talk: Using SAS/ACCESS to Amazon Redshift, a five-minute recording that demonstrates SAS/ACCESS to Amazon Redshift in action and highlights its performance benefits.
Hi Team,
Working in SAS2AWS conversion project , in one of my code we are using VBscript where we are replacing ~ symbol with the \n using the below part in the VBscript,
strNewText = Replace(strText, "~", "~"& vbCrLf )
But this is working in SA9.3 but not in SAS9.4.
Could some one please help on this in way how to update it in so that it will work under LINUX 9.4.
Hi @PrabhakarC,
Thanks for your question! If you've not already, I suggest opening a SAS Technical Support track for this scenario. The team there should be able to work through this with you.
Anna
Thanks @AnnaBrown , I have created ticket under the given request.
Wonderful to hear, @PrabhakarC. Thanks for using the communities!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.