Problem Note 69948: Opening a SAS® view in SAS® Studio (Enterprise) might return errors if the view was created with more than four UNION instructions
 |  |  |  |  |
Opening a SAS view in SAS Studio (Enterprise) might return errors if you complete steps similar to the following.
- Execute SQL procedure code similar to the following in SAS Studio (Enterprise): http://hostname/SASStudioV
create view SAMPLE as
(select "ANNEE_COMPTA" as nom_param, &_annee_compta_fc. as val_param from base)
union (select "CODE_VERSION_FC" as nom_param, &_CODE_VERSION_FC. as val_param from base)
union (select "MAX_CODE_V_FC" as nom_param, &_MAX_CODE_V_FC. as val_param from base)
union (select "LAST_CODE_V_FC" as nom_param, &_LAST_CODE_V_FC. as val_param from base)
union (select "MOIS_PARAM" as nom_param, &_MOIS_PARAM. as val_param from base)
union (select "FLAG_BP" as nom_param, &_FLAG_BP. as val_param from base)
;
quit;
The PROC SQL code creates a SAS view called SAMPLE in your WORK library.
- Expand the WORK library in the SAS Studio Libraries pane and double-click the SAS view to open it. One of the errors below might appear:
Note: This issue occurs when you create the view with more than four UNION instructions.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Studio for Viya | Microsoft® Windows® for x64 | 5.2 | Stable 2023.02 | Viya | Viya platform |
| Linux for x64 | 5.2 | Stable 2023.02 | Viya | Viya platform | ||
Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2023-07-17 09:07:53 |
| Date Created: | 2023-03-15 06:17:46 |