SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 20061: Certain CASE syntax might not migrate correctly in SAS® Enterprise Guide®

DetailsHotfixAboutRate It
CASE syntax similar to the following entered into the Expression window
of the Query builder might not migrate correctly from SAS Enterprise
Guide 2.x to 4.1.

   case class.'name'n
     when 'Joyce' then 1
     when 'William' then 2
     when 'Jane' then 3
     else 0
   end

In the above example, the query will execute in SAS Enterprise Guide
2.x. However, after migrating the project to SAS Enterprise Guide 4.1,
if the query is opened, and you attempt to edit the computed column, an
Application Error will likely be generated.

If you run the query instead of opening it, this error will likely be
generated:

   Error: Unable to get SAS code.
          Object reference not set to an instance of an object.

To circumvent the problem, open the project using SAS Enterprise Guide
2.x and edit the CASE syntax similar to this example:

   case
     when class.name = 'Joyce' then 1
     when class.name = 'William' then 2
     when class.name = 'Jane' then 3
     else 0
   end

Save the project and then open it using SAS Enterprise Guide 4.1.0.500.
You should then be able to edit or run the queries.

Select the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Enterprise GuideMicrosoft Windows XP Professional4.14.29.1 TS1M3 SP19.2 TS2M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.