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 (May 2012, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 9 May 2012 10:24:11 -0400
Reply-To:     Subhadra Srigiriraju <subhadrasri@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Subhadra Srigiriraju <subhadrasri@GMAIL.COM>
Subject:      Re: ERROR: Sort execution failure.
Comments: To: Irin later <irinfigvam@yahoo.com>
In-Reply-To:  <1336572314.87942.YahooMailNeo@web39406.mail.mud.yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1

Probably a memory issue, here is the link from search:

http://support.sas.com/kb/42/681.html

On Wed, May 9, 2012 at 10:05 AM, Irin later <irinfigvam@yahoo.com> wrote:

> Log gave me an error which I was unable to interpret... > > I am trying to extract information from DW to join to an existing > HospDisch tables in order to get as many records as in HospDisch table. > > The purpose is to get additional admission details (patients visiting > physition office after hospital discharge). > > That is why I need fields from the DW tables as additional fields for > HospDisch table records. > Why system gave me "ERROR: Sort execution failure"? What does it mean? > What I am doing wrong? > > Thank you in advance, > > Irin > > > 951 Proc SQL; > 952 Create table irHosptAC_Visits_ as > 953 select distinct > 954 a.Memberid > 955 ,cl.claimid > 956 ,cl.ServiceDateFrom > 957 ,cl.PrimaryDiagnosisCode > 958 ,a.AdmitDate > 959 ,a.LOSp > 960 ,a.HospDischDate > 961 ,a.KEY_ > 962 ,a.AGE > 963 ,a.AGEDAY > 964 ,a.SEX > 965 ,a.RACE > 966 ,a.PSTCO > 967 ,a.HOSPID > 968 ,a.ATYPE > 969 ,a.ASOURCE > 970 ,a.DRG > 971 ,a.DRG_Precidiem > 972 ,a.MDC > 973 ,a.DX1 > 974 ,a.DX2 > 975 ,a.DX3 > 976 ,a.DX4 > 977 ,a.DX5 > 978 ,a.DX6 > 979 ,a.PR1 > 980 ,a.PR2 > 981 ,a.PR3 > 982 ,a.PR4 > 983 ,a.PR5 > 984 ,a.PR6 > 985 ,a.PR7 > 986 ,a.PR8 > 987 ,a.YEAR > 988 ,a.DQTR > 989 ,a.Rating_Category > 990 ,a.PROGRAM > 991 ,a.CLAIMID as HospClaim > 992 ,a.paidamount > 993 ,a.PointofOriginUB04 > 994 ,a.PCPSiteid > 995 ,a.PCPSiteNHPId > 996 ,a.PCPSiteName > 997 ,a.MemberName > 998 ,a.eventid1 > 999 ,a.PayToProviderid > 1000 ,a.PayToProviderName > 1001 ,CEDM.EventID > 1002 ,ed.event_pk > 1003 ,ch.claimstatus > 1004 FROM MYLIBREF.ClaimLine cl > 1005 INNER JOIN MYLIBREF.CoeEventDimMap CEDM ON (CEDM.ClaimID = CL.ClaimID > and CEDM.LineNumber > 1005! = cl.LineNumber) > 1006 INNER JOIN MYLIBREF.Event_DIM ED ON ED.Event_PK = CEDM.Event_PK > 1007 inner join MYLIBREF.Claimheader ch ON CH.ClaimID = CL.ClaimID > 1008 INNER JOIN HospDisch a on a.memberid=ch.memberid > 1009 where substr(ed.level3,1,9)='Physician' > 1010 and ch.claimstatus='PAID' AND > 1011 ch.LastserviceTransactionFlag='y' > 1012 and ( > 1013 (year(datepart(cl.ServiceDateFrom))=2010 and > month(datepart(cl.ServiceDateFrom))in > 1013! (10,11,12)) > 1014 or > 1015 (year(datepart(cl.ServiceDateFrom))=2011 and > month(datepart(cl.ServiceDateFrom))in > 1015! (1,2,3,4,5,6,7,8,9)) > 1016 ); > ERROR: Sort execution failure. > 1017 quit; > NOTE: The SAS System stopped processing this step because of errors. > NOTE: PROCEDURE SQL used (Total process time): > real time 2:06:37.14 > cpu time 23:53.29 >


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