SORT EXECUTION FAILURE WHILE LEFT JOINING

Shanthi123 — Thu, 25 Apr 2024 12:29:36 GMT

Hello,

can some one help me to resolve sort execution failure while am doing left join .

PROC SQL;
	CREATE TABLE MW_ORG_INFO1 AS
	SELECT 	 DISTINCT A.ITEMNO
			,A.ORGCD
	FROM
		 TDMH2K.MAMM_PART_CHANGE_TRACKER	A
	WHERE 	A.GNO_FACILITY_CODE='92'
		AND A.CHANGE_DATE = 
			(	
				SELECT MAX(B.CHANGE_DATE) 	
				FROM TDMH2K.MAMM_PART_CHANGE_TRACKER	B
				WHERE 	A.ITEMNO=B.ITEMNO
					AND A.GNO_FACILITY_CODE=B.GNO_FACILITY_CODE
					AND B.ORGCD NE ' '
			)
	ORDER BY ITEMNO;

QUIT; 
RUN;
PROC SORT DATA=MW_ORG_INFO1 NODUPKEY; BY ITEMNO; RUN;
/**** Added on 25 April 2024 *****/
DATA GLB_LC_ITM (RENAME=(LC_ITM_TYP =ORG_CD  ));
	SET PR01GI.GLB_LC_ITM ;
	length NODE $3.;
	length ACSD $3.;
	FAC_CD=SUBSTR(LOG_CTR_CD,3) ;
	DROP LOG_CTR_CD;
If LC_ITM_TYP IN('BPP','KIT','NJORG','OAD','SPP','WPC') then NODE='NO';
Else NODE='YES';
IF LC_ITM_TYP IN('BPP','KIT','NJORG','OAD','SPP','WPC','CMD','LWL','MTH','MWL','PWR') 
THEN ACSD='NO' ;
ELSE ACSD='YES';
RUN;
/**** Added on 25 April 2024 *****/

PROC SQL;
	CREATE TABLE MW_ORG_INFO2 AS 
	SELECT	A.*
			,B.FAC_CD
			,B.NODE
			,B.ACSD
	FROM MW_ORG_INFO1 AS A LEFT JOIN GLB_LC_ITM  AS B ON A.ORGCD=B.ORG_CD
	ORDER BY A.ITEMNO;
QUIT;
RUN;

am getting error in the last step. while doing left join.

dataset A is having around 75k records and dataset B has 308K records.

ERROR: SORT EXECUTION FAILURE.

Re: SORT EXECUTION FAILURE WHILE LEFT JOINING

SASJedi — Thu, 25 Apr 2024 12:59:28 GMT

Have a look at the Troubleshooting "Sort initialization failure" and "Sort execution failure" errors in Windows and UNIX environments for some suggestions on how to troubleshoot and fix this problem.

Re: SORT EXECUTION FAILURE WHILE LEFT JOINING

Shanthi123 — Thu, 25 Apr 2024 13:03:06 GMT

Thank you @SASJedi

let me go through this.

topic SORT EXECUTION FAILURE WHILE LEFT JOINING in SAS Programming

SORT EXECUTION FAILURE WHILE LEFT JOINING

Re: SORT EXECUTION FAILURE WHILE LEFT JOINING

Re: SORT EXECUTION FAILURE WHILE LEFT JOINING