topic Re: libname statement in SAS Programming

libname statement

kate94 — Thu, 31 May 2018 08:27:09 GMT

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 🙂

Re: libname statement

RW9 — Thu, 31 May 2018 08:57:48 GMT

Step 1) Read the manual:

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

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.

Re: libname statement

kate94 — Thu, 31 May 2018 12:21:32 GMT

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 🙂

Re: libname statement

LinusH — Thu, 31 May 2018 14:20:48 GMT

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.

Re: libname statement

kate94 — Thu, 31 May 2018 15:27:20 GMT

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 😉

Re: libname statement

maggiem_sas — Mon, 04 Jun 2018 14:34:04 GMT

Have you followed the SAS Hadoop Configuration Guide for Base SAS and SAS/ACCESS?

https://support.sas.com/content/dam/SAS/support/en/documentation/third-party-reference/493970_9.4-hadoopbacg-4th-ed-1217.pdf

More information is at:

https://support.sas.com/en/documentation/third-party-software-reference/9-4/guides-papers-for-hadoop.html