Blogging about all things SAS

So after converting a few EG project from SAS 9.1/EG 4.1 to SAS 9.2/EG 4.2 I have found a few interesting experiences.

I have just posted my experience with the EG Migration Wizard

Once the EG project is in 4,2 format a few other things have surfaced:

• When importing MS Access or Excel files in the project, the import function has seemed to fundamentally changed, this caused a number of issues, specifically around importing date fields
• Also it changes the title of the import file node from the database or excel file name to the access table or excel sheet name.  A little frustrating when multiple excel spreadsheets are being imported and they are all based on sheet1!
• The query wizard has changed the way it handles calculations on calculated items, not sure exactly how, but query nodes that worked fine in 4.1 error in 4.2.  However once we recreated these calcs manually it all worked fine.

Little niggles and all can be fixed, but again don’t under estimate the amount of effort to get these things converted.