question

Patrick-0115 avatar image
0 Votes"
Patrick-0115 asked KranthiPakala-MSFT answered

Using ADF to read SAS files

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.

azure-data-factoryazure-data-lake-storage
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered

Hi @Patrick-0115,

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.




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.