BookmarkSubscribeRSS Feed
Jessy
Fluorite | Level 6

Hey there,

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.

Thank you

3 REPLIES 3
SASKiwi
PROC Star

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.

Jessy
Fluorite | Level 6

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

SASKiwi
PROC Star

The issues we found in moving from SAS 9.3 to 9.4 were:

  • The data order of SQL queries was sometimes different to 9.3. We had to add ORDER BY clauses to correct this
  • SQL sub-queries with GROUP BY's sometimes gave wrong results. These could be fixed by adding AS ColumnName to column selected
  • PROC IMPORT of Excel spreadsheets now only allows MIXED = YES statement if DBMS = EXCEL. Code change required.
  • Struck a bug with the EXCELXP ODS tagset documented in SAS Note 53344 - fortunately there is a workaround.

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. 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 872 views
  • 2 likes
  • 2 in conversation