Hey - In response to the Proc Hadoop question:
The issue here is that the file that you are attempting to copy is not being found. This is the relevant error line from the java trace back: ERROR: java.io.FileNotFoundException: File /home/cloudera/Desktop/samplenew.txt does not exist
Based on the path that you are trying to copy, I'm guessing that the file is located on the server's local file system... When you use Proc Hadoop, it only connects to the Hadoop File System (HDFS) and therefore can only access files that are within HDFS.
So a couple suggestions, if you want to use that file, copy it to hdfs using the VM command line and the "hadoop fs -put" or "hadoop fs -copyFromLocal" (it may be 'hdfs dfs' instead of 'hadoop fs' depending on your version of Hadoop). Otherwise, I'd suggest you creating a local file on your Windows box and trying a proc hadoop copyfromlocal to the directory that you create.
Based on your code comment, to put a file on HDFS you'd want to use copyfromlocal. Copyfromlocal will copy a file from your Windows local file system to HDFS on the cloudera VM, while copytolocal will copy a file from HDFS on the cloudera VM to your Windows local file system
Below I have revised your proc hadoop code and included an example of both types of copy statements. The code below would in theory create '/user/sas/newdir' on your Cloudera VM's HDFS, it would then copy a file from your windows box to the Cloudera VM's HDFS, and finally copy it back to your Windows local file system. You would have to correct the X'ed password, and ensure that 'D:\hadoop\sample.txt' existed before running the code.
options set=SAS_HADOOP_CONFIG_PATH="D:\hadoop\conf";
options set=SAS_HADOOP_JAR_PATH="D:\hadoop\jarlib";
proc hadoop username='cloudera' password=XXXXXXXXXX verbose;
hdfs mkdir='/user/sas/newdir';
hdfs copyfromlocal='D:\hadoop\sample.txt' out='/user/sas/samplenew.txt' ;
hdfs copytolocal='/user/sas/samplenew.txt' out='D:\hadoop\sampletest.txt' ;
run;
I do not know much about libname statements, and will not be able to address those errors - but I do hope this gets you running with Proc Hadoop.
... View more