LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (April 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 12 Apr 2002 09:12:33 -0700
Reply-To:   Steve <steve.silver@SUNTRUST.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Steve <steve.silver@SUNTRUST.COM>
Organization:   http://groups.google.com/
Subject:   YZR malfunction: file WORK.AAMTMCH.DATA trashed or YZR code bug
Content-Type:   text/plain; charset=ISO-8859-1

I am receiving this message running a PROC SQL on an IBM Mainframe 390 using SAS v8.0. The Proc SQL concatenates 3 SAS data sets as follows:

000253 CREATE TABLE RET_TRAN AS 000254 SELECT * 000255 FROM TAMTMCH 000256 OUTER UNION CORRESPONDING 000257 SELECT * 000258 FROM TONLYMCH 000259 OUTER UNION CORRESPONDING 000260 SELECT * 000261 FROM AAMTMCH 000262 OUTER UNION CORRESPONDING 000263 SELECT * 000264 FROM AONLYMCH 000265 ORDER BY PGM_CD, POST_DAT, EX_TRANS, ACCT;

When looking up the message at the SAS website, it says either there is a bad disk track or the SAS data set is corrupt. I have proved that neither is the case in my situation. I am able to read each of the three data sets using data _null_ steps prior to the PROC SQL.

If anyone has received this error, I would appreciate hearing from you about your experience and how you solved the problem.

Thanks for your time,

Steve Silver SunTrust Bank


Back to: Top of message | Previous page | Main SAS-L page