Problem Note 20061: Certain CASE syntax might not migrate correctly in SAS® Enterprise
Guide®
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
SAS System | SAS Enterprise Guide | Microsoft Windows XP Professional | 4.1 | 4.2 | 9.1 TS1M3 SP1 | 9.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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2007-09-07 14:48:49 |
Date Created: | 2007-04-26 15:24:31 |