Hello All,
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.
;
RUN;
DATA DB2DB.DEALER_MGMT_FILL_GOAL;
MODIFY DB2DB.DEALER_MGMT_FILL_GOAL
LOADFL ;
BY DEALER_NUMBER FILL_GOAL_YEAR ;
FILL_GOAL = FILL_GOALX ;
IF _IORC_ = %SYSRC(_SOK) THEN REPLACE ;
ELSE IF _IORC_ = %SYSRC(_DSENMR) THEN
DO;
_ERROR_ = 0 ;
_IORC_ = 0 ;
OUTPUT ;
END;
RUN;
sas error:
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.
Hi,
Does the following apply:
http://support.sas.com/kb/6/720.html
If so, you might just need an extra option on the libname statement.
Regards,
Amir.
That did solve the issue !! thanks a lot Amir.
I am also facing same issue. Can you please provide me solution as SAS Support page is not available now.
it's this option for libname statement:
REREAD_EXPOSURE = YES
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.