Using ADF to read SAS files

Question

Hello,

Please is there a way ADF can read SAS files or convert SAS files into csv format?
.sas7bdat

I would appreciate any assistance on this.

Answer 1

Hi @Patrick ,

Welcome to Microsoft Q&A forum and thanks for posting your query.

Unfortunately .SAS file format is not supported by Azure Data factory. For a list of Azure Data Factory support file formats. Please refer to this doc: Supported file formats and compression codecs by copy activity in Azure Data Factory and Azure Synapse pipelines

To move data to/from a data store that the service does not support, or to transform/process data in a way that isn't supported by the service, you can create a Custom activity with your own data movement or transformation logic and use the activity in a pipeline. The custom activity runs your customized code logic on an Azure Batch pool of virtual machines.

Hope this info helps. Do let us know if you have further query.

----------

• Please accept an answer and up-vote if it helps. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.