SAS Support Site Home | Samples and SAS Notes Home
SAS Notes V6-AF-E095
Click on last row in Data Table and page down with arrow key alters data


If you execute a Data Table object in a SAS/AF FRAME entry, click on thelast visible row that is either partially or fully displayed, and move to the next row by using the down arrow key, data values displayed in the row that you move to with the arrow key may be automatically updatedto either a 0 or exponential number for a numeric column or a blank or some odd text string for a character column.

This may happen when you have opened the data set displayed in the data table with member-level locking by calling the _SET_DATASET_ method and are executing model SCL that contains a TERM label. Only those columns that you have referenced by name in the model's SCL entry may be updatedwith these incorrect values.

You can circumvent this problem by removing the TERM label from the model's SCL entry, opening the data set with record-level locking, opening the data set through the Data Table Attributes window rather than by executing _SET_DATASET_, or by disabling partial rows. To disable partial rows, deselect "Partial rows" under Customize table -> Setup or execute the _SET_ATTRIBUTES_ method and set the PARTIAL_ROWS attribute to "N".


Products: AF
Component: AF
Priority: ALERT
Status: Outstanding Problem
Date: Tue, 16 Sep 1997

System Release Reported Release Fixed
AIX/6000 6.12 TS020 6.12 TS045  
HP-UX Operating Systems 6.12 TS020 6.12 TS045  
IBM OS/2 6.12 TS020 6.12 TS045  
Solaris 6.12 TS020 6.12 TS045  
OpenVMS Alpha 6.12 TS020 6.12 TS045  
Windows 3.11 6.12 TS020 6.12 TS045  
Windows NT 6.12 TS020 6.12 TS045  
Windows 95 6.12 TS020 6.12 TS045  
Compaq Tru64 Unix 6.12 TS040  
Macintosh 6.12 TS040  

No Fixes Available