https://communities.sas.com/t5/SAS-Data-Management/Write-Data-to-AWS-S3-Parquet-file-9-4m7/m-p/801051#M20276 <P>Hi, we've got a split economy with our infrastructure. A lot of our data is processed via SAS and loaded into SQL DB's, we also have a lot of users/data on AWS/Databricks. I've been tasked with seeing if we can get our SAS Environment to also load the data into our AWS Environment ideally as par.</P> <P>&nbsp;</P> <P>I've done some research and found Proc S3 but that seems to do flat files, can it do parquet files? There's also CASLIB too but that looks to do temp tables (SAS tables?). I've found some info but a lot seems to be for VIYA rather than 9.4(M7) that we're running.</P> <P>&nbsp;</P> <P>Thanks</P> Wed, 09 Mar 2022 12:15:54 GMT MRDM 2022-03-09T12:15:54Z https://communities.sas.com/t5/SAS-Data-Management/Write-Data-to-AWS-S3-Parquet-file-9-4m7/m-p/801051#M20276 <P>Hi, we've got a split economy with our infrastructure. A lot of our data is processed via SAS and loaded into SQL DB's, we also have a lot of users/data on AWS/Databricks. I've been tasked with seeing if we can get our SAS Environment to also load the data into our AWS Environment ideally as par.</P> <P>&nbsp;</P> <P>I've done some research and found Proc S3 but that seems to do flat files, can it do parquet files? There's also CASLIB too but that looks to do temp tables (SAS tables?). I've found some info but a lot seems to be for VIYA rather than 9.4(M7) that we're running.</P> <P>&nbsp;</P> <P>Thanks</P> Wed, 09 Mar 2022 12:15:54 GMT https://communities.sas.com/t5/SAS-Data-Management/Write-Data-to-AWS-S3-Parquet-file-9-4m7/m-p/801051#M20276 MRDM 2022-03-09T12:15:54Z https://communities.sas.com/t5/SAS-Data-Management/Write-Data-to-AWS-S3-Parquet-file-9-4m7/m-p/801205#M20279 <P>Does this library article help?&nbsp;<A href="https://communities.sas.com/t5/SAS-Communities-Library/Accessing-Azure-Databricks-from-SAS-9-4/ta-p/758137" target="_blank">Accessing Azure Databricks from SAS 9.4</A></P> Thu, 10 Mar 2022 00:19:17 GMT https://communities.sas.com/t5/SAS-Data-Management/Write-Data-to-AWS-S3-Parquet-file-9-4m7/m-p/801205#M20279 SASKiwi 2022-03-10T00:19:17Z