Hi,
I would like to know which is needed to execute SAS processes in a Hadoop cluster.
I can convert my data setps and proc sql to proc ds2 processes but I want to know if I need some especial licenses in Hadoop to work with SAS. SAS HPA??, SAS/ACCESS to Hadoop?, SAS in-database? any other? is any of these free ?
Thanks in advance
I'm doing the same thing - understanding the relationship between SAS & Hadoop and coming up with best practices to get programmers to use Hadoop effectively without creating horrendous SQL joins with non-Hadoop tables & causing massive I/O pipeline blockages..
I suggest you review the following documentation:
None of the software is "free" - there is some Hadoop functionality which comes with Base/SAS, but ideally you'd require at least the SAS/Access to Hadoop engine, and - depending on your requirements - possibly some in-database accelerators.
I'm doing the same thing - understanding the relationship between SAS & Hadoop and coming up with best practices to get programmers to use Hadoop effectively without creating horrendous SQL joins with non-Hadoop tables & causing massive I/O pipeline blockages..
I suggest you review the following documentation:
None of the software is "free" - there is some Hadoop functionality which comes with Base/SAS, but ideally you'd require at least the SAS/Access to Hadoop engine, and - depending on your requirements - possibly some in-database accelerators.
My (limited) understanding is that in-database processing requires its namesake license, which is apparently now par of SAS® Data Loader for Hadoop.
SAS/ACCESS to Hadoop is the interface to Hive.
SAS/ACCESS to Impala is useful too to speed up queries.
None of these are free.
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 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.