Problem Note 67045: The length of a VARCHAR variable in a table view is incorrectly listed as 0 when the original data source is a Postgres file
 |  |  |  |  |
The CASUTIL procedure with the CONTENTS statement shows an incorrect length of 0 for VARCHAR variables when the original source is a Postgres file.
This issue happens only when the Postgres file is loaded into SAS® Cloud Analytic Services (CAS) and you then create a view from the table.
This problem does not occur with a view that is created from a table where the original source file is not a Postgres file.
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 Viya | Linux for x64 | 3.5 | 3.5 | Viya | Viya |
Viya 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: | 2021-01-22 15:34:49 |
| Date Created: | 2020-12-04 08:52:59 |