I have an issue with exporting a SAS dataset into an Hadoop file location. All of the documentation that I have seen is exporting a file from local computer that is already in txt format.
The file I am trying to export to Hadoop is in my 'work' library and the hdfs path is /Data/direct/abs/
libname out hadoop "/Data/direct/abs/" dir user="&user";
proc sql;
create table out.results_set (COLUMN_DELIMITER = '|') as
select * from work.custlist;
quit;
Thank you. I changed to libname and it is still now working. Says "Engine does not accept a physical name". Could it be my path that it is not accepting?
With SAS/ACCESS engines, you usually do not refer to physical (file system) paths. For Hive, you need torefer to a Hive data base.
I think I could be wise ti visit SAS documentation page for SAS/ACCESS to Hadoop, so you can pick up the correct syntax and per-requisites.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.