topic Re: Read SAS datasets stored on Microsoft Azure ADLS using SAS9.4 or SAS EG in New SAS User

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

apat861 — Mon, 27 Feb 2023 17:16:31 GMT

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?

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

SASKiwi — Mon, 27 Feb 2023 19:23:24 GMT

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

Re: Read SAS datasets stored on Microsoft Azure ADLS using SAS9.4 or SAS EG

apat861 — Mon, 27 Feb 2023 19:32:02 GMT

Hi,

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

Re: Read SAS datasets stored on Microsoft Azure ADLS using SAS9.4 or SAS EG

SASKiwi — Mon, 27 Feb 2023 19:41:49 GMT

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.

Re: Read SAS datasets stored on Microsoft Azure ADLS using SAS9.4 or SAS EG

apat861 — Tue, 28 Feb 2023 13:31:11 GMT

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?

Re: Read SAS datasets stored on Microsoft Azure ADLS using SAS9.4 or SAS EG

ChrisHemedinger — Tue, 28 Feb 2023 13:47:10 GMT

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.