BookmarkSubscribeRSS Feed
codek
Fluorite | Level 6

How to access sas7bdat files stored in Azure ADLS Gen2 storage in SAS studio ? Is it possible to configure ADLS gen2  in sas studio as  like local folders and consume them ?

I want to access the ADLS gen2 data for data analysis through SAS.   

12 REPLIES 12
SASKiwi
PROC Star

I would think ADLS Gen 2 storage setup and configuration is more of an administrative task that you would do in Azure not SAS. You can read existing ADLS data though. What SAS version and maintenance level are you using? Support for ADLS in SAS was fairly recent. There is a lot of new functionality in SAS Viya like this: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/casref/n1ogaeli0qbctqn1e3fx8gz70lkq.htm

 

codek
Fluorite | Level 6

Yes ADLS set up is done. My clarification is how to  access ADLS storage through SAS studio(Release: 3.8 (Enterprise Edition)) . My data is in ADLS gen2 . Is it possible to access ADLS gen2 stored data through SAS studio ? Can we be able to map the ADLS storage as local to SAS and access it  without copying the data to SAS storage (if anything)  ? Or we need to copy the ADLS gen2 data into SAS storage and access it ?

Kurt_Bremser
Super User

The Base engine needs the .sas7bdat files to be available in the local filesystem; alternatively, you may be able to use the "abfss://..." notation to access the file directly (https://docs.databricks.com/external-data/azure-storage.html).

codek
Fluorite | Level 6
can we use abfs in sas studio ? Did not get you how to browse the files present in Azure lake (ADLS gen2 storage) in SAS studio ?
Kurt_Bremser
Super User

SAS Studio is not the point here. To work with a SAS dataset, the SAS Workspace Server process must be able to access it, so it must be located within the server filesystem (or maybe you can use the abfss:// method wherever a physical path is allowed/required).

codek
Fluorite | Level 6

data is already there in Azure storage. if i copy to SAS workspace server again, then its data duplication . i could not find any link as a reference for abfss access in SAS programming language. 

 

SAS viya reference link  for ADLS :

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/casref/n1ogaeli0qbctqn1e3fx8gz70lkq.htm

SASKiwi
PROC Star

SAS Studio version 3.8 is available with SAS 9.4M6 or M7. The only ADLS functionality I'm aware of in SAS 9.4 is this: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lestmtsglobal/n0yc4ac0hf1yefn1r504kw2uesiw.ht...

codek
Fluorite | Level 6

I referred this link.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/casref/n1ogaeli0qbctqn1e3fx8gz70lkq.htm#n1s2t...

 

Per above link , csv and ORC files are supported for ADLS source type. Does it support sas7bdat files as well ?

codek
Fluorite | Level 6

then what is the option to read the sas7bdat files present in ADLS gen2 through  SAS Studio ?

i am not sure if abfss is supported in sas programming language nor i did not get any solution to access it externally.  Does this mean SAS does not support sas7bdat files stored in ADLS gen2 ?

Kurt_Bremser
Super User

SAS dataset files need to be downloaded to the local filesystem of the SAS server.

Unless Azure provides a driver so the cloud instance can be mounted on a filesystem (like NFS or SMB).

SASKiwi
PROC Star

I don't believe SAS7BDAT storage on ADLS is currently supported. You can export SAS data to various ADLS file formats or databases. This paper provides useful info on how SAS interacts with ADSL: https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4266-2020.pdf

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 12 replies
  • 1678 views
  • 1 like
  • 3 in conversation