Hi, as per my question above. I'm using SQL dataware house and doing query through ODBC. When it run until the second part of the code which is sorting the dataset, the temp file getting bigger and bigger until burst my storage. Anyone know what is the issue? Thank you. My code as below. Where the create date and complete date is in Datetime22.3 format and the number of observation around 13 million and my available storage around 70GB. LIBNAME NEDGLOR ODBC DATASRC=NEDGLOR SCHEMA=DBO; PROC SQL; CREATE TABLE SASUSER.TBL_WF_ST_ACT_USER AS SELECT PRO_ID, CREATE_DATE, ACT_DEF_NAME, APP_STATUS_CODE, COMPLETE_DATE, CUSTOM_COLUMN1 FROM NEDGLOR.TBL_WF_ST_ACT_USER ; QUIT; PROC SORT DATA=TBL_WF_ST_ACT_USER; BY PRO_ID DESCENDING CREATE DATE DESCENDING ACT_DEF_NAME; RUN;
... View more