DATA Step, Macro, Functions and more

Upgrade SAS 9.2 to SAS 9.4 to use SAS In-Database Procedures for hadoop

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Upgrade SAS 9.2 to SAS 9.4 to use SAS In-Database Procedures for hadoop

Hi,

 

We have a complete application  with thousand of programs coded in SAS Base 9.2. and we would like to start executing them insight a Hadoop Cluster. 

 

¿Are we going to need recoding programs in some way or just upgrade SAS versión to 9.4? 

 

Thanks


Accepted Solutions
Solution
‎02-09-2017 03:54 AM
Super User
Posts: 5,424

Re: Upgrade SAS 9.2 to SAS 9.4 to use SAS In-Database Procedures for hadoop

Technically they should run, but there might some limitations on what kind of update operations that you can perform in Hive (asumed target...).
But you probably need to go through the code to take advantage of your cluster. No idea what kind of SAS programmers you have but they tend not to optimize their code that much, like having lot of intermediate tables which in your case will be in Base SAS work tables.
Just out of curiosity, is it the same data that will be move to Hadoop that you have in SAS now? If your data isn't huge you might experience worse perform Hadoop than in your original environment.

You say in-database. Can you be more specific what functionality you are looking for? This term is usually coupled with publishing SAS scoring models and similar as dbms UDFs.
Data never sleeps

View solution in original post


All Replies
Solution
‎02-09-2017 03:54 AM
Super User
Posts: 5,424

Re: Upgrade SAS 9.2 to SAS 9.4 to use SAS In-Database Procedures for hadoop

Technically they should run, but there might some limitations on what kind of update operations that you can perform in Hive (asumed target...).
But you probably need to go through the code to take advantage of your cluster. No idea what kind of SAS programmers you have but they tend not to optimize their code that much, like having lot of intermediate tables which in your case will be in Base SAS work tables.
Just out of curiosity, is it the same data that will be move to Hadoop that you have in SAS now? If your data isn't huge you might experience worse perform Hadoop than in your original environment.

You say in-database. Can you be more specific what functionality you are looking for? This term is usually coupled with publishing SAS scoring models and similar as dbms UDFs.
Data never sleeps
New Contributor
Posts: 2

Re: Upgrade SAS 9.2 to SAS 9.4 to use SAS In-Database Procedures for hadoop

This "preliminar analisys" is just what I needed

Thanks LinusH !
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 112 views
  • 1 like
  • 2 in conversation