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

[DSTM]

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

[LinusH · Accepted solution]

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.

[DSTM]

This "preliminar analisys" is just what I needed

Thanks LinusH !