SUPPORT / SAMPLES & SAS NOTES
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
proc sql;
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;
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 | ||