| 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. |
|---|
|
| 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
>
|
