06-28-2015 08:55 PM
Can anybody let me know, what are the things to be checked on the programs, when we update SAS EG from 6.1 to 7.1 in order to see if the programs are working the same as they used to in the older EG version. I know few things, like comparing the run time, output, and the log for any additional warnings/errors. Are there any other things to be added to the list. Please provide your inputs.
06-28-2015 09:28 PM
Are you changing SAS versions too? Do you use EG projects or just you own written code?
If you are not changing SAS versions and run only code then only functional testing is required - do your programs run without error or not.
We've just changed EG versions but not SAS version and have only user-written code. Everything ran fine with minimal functional testing.
If you are changing SAS versions say 9.3 to 9.4, then full regression testing is required including checking data. I found some significant issues when doing this.
06-28-2015 09:39 PM
We use written codes and we'll be switching from 9.3 to 9.4 as well. Can you share the issues you found in 9.4 please.
Thank you very much
06-29-2015 12:15 AM
The issues we found in moving from SAS 9.3 to 9.4 were:
The SQL problems were tracked with Tech Support. They were acknowledged as a problem and forwarded to SAS R & D.
The lesson from this exercise is that changing SAS versions requires comprehensive testing.
We used PROC COMPARE extensively to ensure important datasets were indeed identical. It is a fantastic utility for this type of work and should be an essential part of every SAS developers toolkit.