how to connect SAS Enterprise to Azure Blob storage account

[beebeebee]

my software version is this:

SAS Enterprise Guide 7.15 HF8 (64-bit)
SAS version 9.4

thank you!

[SASKiwi]

Start by checking what SAS/ACCESS products you have available to you and post here:

proc product_status;
run;
proc setinit;
run;

AFAIK SAS 9.4 can't process BLOBs, only character and numeric data.

[beebeebee]

thanks for your reply.

i am looking to get "files" containing plain text from Azure Blob storage.

the original question is, what is the connection string to an Azure Blob storage?

my intention is to perform REST calls as documented here:

https://docs.microsoft.com/en-us/rest/api/storageservices/blob-service-rest-api

[StefanosKe]

Does anyone know if this is still not possible?

[SASKiwi]

This is the answer I got when I asked Google:

You will need to provde more details regarding your specific requirements.

[StefanosKe]

- there is this post https://communities.sas.com/t5/SAS-Communities-Library/Using-Azure-Blob-Storage-for-sas7bdat-files-w... for accessing sas7bdat files in Azure blob via Viya. 

- In this post: https://communities.sas.com/t5/New-SAS-User/Read-SAS-datasets-stored-on-Microsoft-Azure-ADBL-using-S...

 @ChrisHemedinger suggests a solution to use Proc HTTP and download the data locally, but as you can imagine this is not ideal. Chris also mentions that assigning a fileref to Azure Blob Storage is possible in SAS Viya. Cant we also do something in SAS EG/9.4, say via NFS?

[SASKiwi]

Your questions are probably best addressed by submitting them in a Tech Support track. The fact that Viya has built-in Azure blob storage capability doesn't necessarily mean something similar is possible in SAS 9.4. 

[StefanosKe]

we are receiving support from a local partner. I will post here the solution when we have it. ty!