DATA Step, Macro, Functions and more

libname statement

Reply
New Contributor
Posts: 3

libname statement

Hi everyone,

 

 

I want SAS to connect to Hadoop with libname or filename statement but i don't no what requirements and informations we need about hadoop or server. I'm just a beginner it's not clear for me. I precise that i don't have sas/Access.

 

 

Thank you to inform me on this subject

 

 

Kate Smiley Happy

Super User
Super User
Posts: 9,402

Re: libname statement

Step 1) Read the manual:

http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#n1h398otek0j00n1it...

 

This is the best source for information, and you can get it by simply typing "SAS " followed by the topic into Google.

From that we can see that this is a SAS/Access tool, so you need that component. 

New Contributor
Posts: 3

Re: libname statement

Thank you for your answer. I have seen  this documentation yet. but i have found also this documention. it deals with how can we connect hadoop from sas without sas/access..

 

 

https://blogs.sas.com/content/sgf/2015/05/29/how-sas-gets-to-data-in-hadoop/

 

 

thank

 

kate Smiley Happy

Super User
Posts: 5,849

Re: libname statement

Your requirement is a bit unclear. Do you have a business use case, or are you just playing around?

If you have a commercial license for Base SAS you have FILENAME access to hdfs, and also PROC HADOOP. For more advance use you can store SPDE data in hdfs.
Configuration: RTM.

Data never sleeps
New Contributor
Posts: 3

Re: libname statement

[ Edited ]

Thank you for your response. No i am not playing around :/ ... but if my requirement is unclear because i am a beginner in IT and it's unclear for me it's true ... oK I understand that I have FILENAME access to hdfs .. nevertheless i don't understand what informations i need to create the connection. i dont understant what is cfg etc

 

filename cfg "C:\Users\sasabc\hadoop\sample_config.xml";
proc hadoop options=cfg username="sasabc" password="sasabc" verbose;
   hdfs mkdir="/user/sasabc/new_directory";
   hdfs delete="/user/sasabc/temp2_directory";
   hdfs copytolocal="/user/sasabc/testdata.txt"
        out="C:\Users\sasabc\Hadoop\testdata.txt" overwrite;
run;

 

 

thank you again

 

kate Smiley Wink 

SAS Employee
Posts: 17

Re: libname statement

Ask a Question
Discussion stats
  • 5 replies
  • 110 views
  • 0 likes
  • 4 in conversation