https://communities.sas.com/t5/SAS-Programming/Migrate-SAS-codes-to-BQ/m-p/843233#M333381 <P>There is no automated way to migrate SAS code to other software tools. SQL will be much the same in the new tool but you will have to change SAS table and column names to whatever you have defined in BigQuery. DATA step code will need to be rewritten in SQL or other supported BigQuery languages.</P> Tue, 08 Nov 2022 20:25:36 GMT SASKiwi 2022-11-08T20:25:36Z https://communities.sas.com/t5/SAS-Programming/Migrate-SAS-codes-to-BQ/m-p/843229#M333380 <P>Hi Team,&nbsp;</P> <P>&nbsp;</P> <P>I have N number of SAS files as txt document - It's a combination of Datastep and Proc SQL. Each file insists normal ETL jobs (like calculate columns, Merge files, keep, drop columns etc). The agenda of the project is to convert/migrate all the operations/function in SAS codes to Google Big query. Is there any possibilities for migrating SAS codes to BQ using any specific automation?</P> <P>&nbsp;</P> <P>Any other effective idea will be appreciated.&nbsp;</P> Tue, 08 Nov 2022 20:00:20 GMT https://communities.sas.com/t5/SAS-Programming/Migrate-SAS-codes-to-BQ/m-p/843229#M333380 Sathish_jammy 2022-11-08T20:00:20Z https://communities.sas.com/t5/SAS-Programming/Migrate-SAS-codes-to-BQ/m-p/843233#M333381 <P>There is no automated way to migrate SAS code to other software tools. SQL will be much the same in the new tool but you will have to change SAS table and column names to whatever you have defined in BigQuery. DATA step code will need to be rewritten in SQL or other supported BigQuery languages.</P> Tue, 08 Nov 2022 20:25:36 GMT https://communities.sas.com/t5/SAS-Programming/Migrate-SAS-codes-to-BQ/m-p/843233#M333381 SASKiwi 2022-11-08T20:25:36Z