On 11/23/2017 17:39, Andrew Rowley wrote:
On 23/11/2017 10:30 PM, Munif Sadek wrote:
SMF/CMF are least of our concern at the moment. We are initially
inclined for any automated tool that can
A.read SAS PDBs and convert them to DB2 tables and/or flat file. Tool
must cater take for packed, COMP data elements.
B. Can read SAS code and give us some basic converted Java code
C. Will be good if the tool can convert DB2I calls to JDBC calls
I suspect the best tool for converting SAS databases to other formats
might be SAS itself. I assume it has interfaces to other types of
database.
My initial thought on converting the code was that SAS code would be
too different to Java, and you would have to work out the specs and
rewrite. However, I googled "convert sas to java" and there seem to be
a number of services and/or products claiming to do it.
I do think the generated code might be less than optimal, and you
would miss out on a lot of the benefits of Java. Rewriting at least
the most resource intensive programs might be worth doing.
I think a better way would be to refine your developer team's Java
skills by writing the SAS->Java conversion tools in Java. For the SAS
specific processes like PROC MEANS, UNIVARIATE, GPLOT, GCHART could be
written as calls to appropriate functions in "R".
/Tom Kern
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
