topic Re: Using SAS on Google Cloud Platform in Administration and Deployment

Using SAS on Google Cloud Platform

u60593051 — Thu, 07 Mar 2024 04:33:54 GMT

Hey y'all,

I have used center for medicaid data on SAS and it struggled to process the big datasets (50 million rows). I recently used Google Cloud Platform. GCP allowed me to store huge datasets and used bigquery to manipulate them seamlessly. I want to use SAS code on Google Cloud Platform to work on my data. is that possible? simply put, i want the data to be stored in GCP and i want to code SAS syntax on GCP. is that possible? I hope that makes sense. Thank you for any tips.

Re: Using SAS on Google Cloud Platform

Patrick — Thu, 07 Mar 2024 04:47:26 GMT

You would likely want SAS Viya/CAS with fast access to the data.

https://www.sas.com/en_au/solutions/cloud/gcp.html

Re: Using SAS on Google Cloud Platform

LinusH — Thu, 07 Mar 2024 13:42:04 GMT

Even if it's preferable to jump on the more cloud ready Viya wagon, it's still possible to install SAS9 on a Google virtual machine.

Re: Using SAS on Google Cloud Platform

gwootton — Thu, 07 Mar 2024 14:01:35 GMT

There is a SAS/ACCESS Interface to Google BigQuery:

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0bm9s8t6t6rr2n1qgkamlgtb0kk.htm

You could use this to engage BigQuery from SAS.

Re: Using SAS on Google Cloud Platform

MargaretC — Thu, 07 Mar 2024 14:36:08 GMT

Here are some papers that discuss running SAS 9 in the Google Cloud.

SAS Deployment on Google Cloud Tips/Tricks including BigQuery Integrat... - SAS Support Communities

Cloud Edition for Lustre on Google Cloud Platform - Whamcloud Community Space - Whamcloud Community Wiki

Re: Using SAS on Google Cloud Platform

SASKiwi — Thu, 07 Mar 2024 19:09:13 GMT

In my experience 50 million rows isn't that big. We frequently process datasets of that size and larger (350m rows for example) using on-premises SAS 9.4 and performance is good. If you start to get up into the thousands of millions of rows then GCP and other big data options would be worth exploring.