Read SAS datasets stored on Microsoft Azure ADBL using SAS9.4 or SAS EG

[apat861]

Hi,

I am using SAS9.4 or SAS EG on my local machine on windows 10 operating system. I have stored SAS format datasets on Microsoft Azure ADBL cloud environment. I want to know how can I read those datasets using SAS9.4 or SAS EG?

[SASKiwi]

How did you store them there in the first place? Were they created by you originally using your Windows SAS?

[apat861]

Hi,

The SAS datasets were provided by third party vendor, and I have uploaded SAS datasets on Microsoft Azure ADLS using Azure Blob.

[SASKiwi]

Did the vendor provide details of how they were created? Like which OS and SAS version was used? I suggest you copy one of them back to your PC and try reading it as a test with your Windows SAS:

libname MyTest 'c:\MyFolder';

If this doesn't work then you are going to have to request the SAS data again in transport format.

[apat861]

Hi,

I can read those files on my location computer using libname statement. But I do not know how to read datasets stored in Microsoft Azure ADLS2 cloud?

[ChrisHemedinger]

SAS Viya has support for assigning a fileref to Azure Blob Storage -- see documentation here.

However, in SAS 9.4, you might need to use Microsoft APIs for this. See the Azure Files APIs documentation. The solution would use PROC HTTP to drive these REST APIs to "download" the files you need to your local system, where you could then assign a library and read with your local SAS. One of the tricky parts may be in the authorization, because each API call will need an authorization key. This key can be provisioned by one of several methods, some of which may require setup from your Azure/tenant admin.