In this blog post, I will explain how to export your data, store it in AWS, and query the data using SAS. Athena can then be your primary, up-to-date data store to share with your colleagues. SAS can use ODBC to connect to Athena while leaving the data in an open format for use by other users and their software of choice that also supports ODBC. Amazon Athena is an interactive query service that uses standard SQL queries to access your data.
In addition to its native file format, SAS is able to read from many other data sources, including the Open Database Connectivity (ODBC) format. Rather than sending data files everywhere, Amazon Web Services (AWS) offers a simple way to store your data in one central location so that you can read your data into SAS and still share it with other colleagues. But if you do this with more than one or two colleagues, you can quickly run into version issues, not knowing which file is the most current. If you share data with other researchers, especially if they are using a different tool, you may try exporting the data as spreadsheet. If you work in data analytics, you are probably familiar with the software package SAS.
0 kommentar(er)
