Problem Note 34756: Column data might be blank using the List Data task in SAS® Enterprise Guide®
When running the List Data task in SAS Enterprise Guide, the results might display a column of blank values. If you look at the data grid, you see the data values for this column without issues. This typically happens on character columns with a length of 4 or less. The problem is caused by a byte alignment on Unix platforms and is most likely to occur on Linux platforms.
A circumvention is to modify the problematic column to a length of 5 or greater. You can do this by executing a query to create a computed column using the original data but setting the length of the new column to 5 or greater.
To create the new column, open the Query Builder and move all of the columns except the character columns with a length of 4 or less onto the Select Data tab. Then, create a Computed Column using the following example as the expression needed to create a copy of the character column with a longer length:
PUT(alias.columnname,$8.)
SAS Enterprise Guide automatically places the new computed column on the Select Data tab. Select Run to run the query and create the column with the longer length. Now, you may run the List Data task on new data and the column should display properly.
An alternative resolution is to apply a related hot fix to the SAS® server. Select the Hot Fix tab in this note to access the hot fix.
Operating System and Release Information
SAS System | SAS Enterprise Guide | 64-bit Enabled AIX | 4.1 | | | |
64-bit Enabled HP-UX | 4.1 | | | |
64-bit Enabled Solaris | 4.1 | | | |
HP-UX IPF | 4.1 | | | |
Linux | 4.1 | | | |
Linux for x64 | 4.1 | | | |
OpenVMS on HP Integrity | 4.1 | | | |
Solaris for x64 | 4.1 | | | |
*
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: | medium |
Date Modified: | 2009-08-12 13:59:31 |
Date Created: | 2009-02-10 15:26:16 |