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

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

DSTM — Wed, 08 Feb 2017 17:35:05 GMT

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

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

LinusH — Wed, 08 Feb 2017 19:12:45 GMT

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.

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

DSTM — Thu, 09 Feb 2017 09:00:50 GMT

This "preliminar analisys" is just what I needed

Thanks LinusH !