09-13-2012 09:28 AM
I am trying to run the below code on SAS 9.2 for Z/OS i.e mainframe and SAS is throwing up an error. anyway i can resolve this ?
OPTIONS ERRORABEND ;
LIBNAME DB2DB DB2 SSID=DB39 SCHEMA=ADRPMMT ;
DATA LOADFL ;
INFILE LOADFL ;
INPUT @001 DEALER_NUMBER $CHAR6.
@008 FILL_GOALX PD3.1
@015 FILL_GOAL_YEAR $CHAR04.
BY DEALER_NUMBER FILL_GOAL_YEAR ;
FILL_GOAL = FILL_GOALX ;
IF _IORC_ = %SYSRC(_SOK) THEN REPLACE ;
ELSE IF _IORC_ = %SYSRC(_DSENMR) THEN
_ERROR_ = 0 ;
_IORC_ = 0 ;
ERROR: File DB2DB.DEALER_MGMT_FILL_GOAL.DATA is sequential.This task requires reading observations in a random order, but the engine allows only sequential access.
NOTE: The SAS System stopped processing this step because of errors.
09-13-2012 01:25 PM
Does the following apply:
If so, you might just need an extra option on the libname statement.
08-11-2016 04:19 AM
I am also facing same issue. Can you please provide me solution as SAS Support page is not available now.