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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.