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