BookmarkSubscribeRSS Feed
kate94
Calcite | Level 5

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 🙂

5 REPLIES 5
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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. 

kate94
Calcite | Level 5

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 🙂

LinusH
Tourmaline | Level 20
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
kate94
Calcite | Level 5

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 😉 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 1255 views
  • 0 likes
  • 4 in conversation