Problem Note 69810: User-defined formats might be lost when you join data sources in SAS® Visual Analytics
When you create a data source join in SAS Visual Analytics and the data sources contain user-defined formats, then the data join table might not retain formats.
For example, you encounter this issue if you perform steps similar to the following:
- Create a new report and add two data sources, CARSFMT and CARS_NOFMT. CARSFMT contains user-defined formats on the Make and Origin columns and CARS_NOFMT does not contain any user-defined formats
- Add a list table or another report object in the canvas and drag the Make and Origin columns into it.
![data source join edits](addl/fusion_69810_3_image1.jpg)
Note that the Make and Origin data items (from the CARSFMT data source) should contain user-defined formats, but they do not, as shown below:
![make and origin data items do not contain user-defined formats](addl/fusion_69810_2_image2.jpg)
As a workaround, use SAS® Studio to create a joined data source, and then use it in SAS Visual Analytics reports.
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
SAS System | SAS Visual Analytics (on SAS Viya 3.x) | Linux for x64 | 8.5.2 | Stable 2023.11 | Viya | Viya platform |
Cloud Foundry | 8.5.2 | Stable 2023.11 | Viya | Viya platform |
Microsoft® Windows® for x64 | 8.5.2 | Stable 2023.11 | Viya | Viya platform |
*
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: | 2024-06-05 08:52:07 |
Date Created: | 2023-01-18 08:24:46 |