[SAS] 두 DATASET비교하기 PROC COMPARE

proc sql ;
create table WORK.Qin_refdata_test as
select HSCODE, TIME, CTY_CODE, EXP_CODE, TRSC_CODE, VALUE_MT, VALUE_QTY, DATA_VALUE, GUBUN, VALUE_UPRICE format 32.19, VALUE_LLIMIT  format 32.19, VALUE_ULIMIT  format 32.19
from WORK.Qin_refdata_test
ORDER BY HSCODE, TIME, CTY_CODE, EXP_CODE, TRSC_CODE, VALUE_MT, VALUE_QTY, DATA_VALUE, GUBUN, VALUE_UPRICE, VALUE_LLIMIT, VALUE_ULIMIT
;
run;
quit;

proc sql ;
create table test_test_svr as
select AVG(VALUE_QTY) format 32.19
from WORK.Qin_refdata_test
;
run;
quit;

/* 일반형태 수출입 및 상하위 범위 이내 자료에 대한 가중평균 단가 산출 */
PROC MEANS DATA=WORK2.QIN_REFDATA_TEST NOPRINT;
    CLASS HSCODE TIME;
    VAR VALUE_UPRICE;
    FREQ VALUE_QTY;
    ID EXP_CODE;
    TYPES HSCODE * TIME; /* HS_월별, HS_월_지역별 자료만 생성 */
    OUTPUT OUT=WORK.QIN_D3_TMP_TEST MEAN=VALUE_MEAN;
    QUIT;
RUN;

proc sql ;
create table WORK.Qin_refdata_test as
select HSCODE, TIME, CTY_CODE, EXP_CODE, TRSC_CODE, VALUE_MT, VALUE_QTY, DATA_VALUE, GUBUN, VALUE_UPRICE format 32.19, VALUE_LLIMIT  format 32.19, VALUE_ULIMIT  format 32.19
from WORK.Qin_refdata_test
ORDER BY HSCODE, TIME, CTY_CODE, EXP_CODE, TRSC_CODE, VALUE_MT, VALUE_QTY, DATA_VALUE, GUBUN, VALUE_UPRICE, VALUE_LLIMIT, VALUE_ULIMIT;
run;
quit;

proc sql ;
create table work.Qin_refdata_test_op as
select  HSCODE, TIME, CTY_CODE, EXP_CODE, TRSC_CODE, VALUE_MT, VALUE_QTY, DATA_VALUE, GUBUN, VALUE_UPRICE format 32.19, VALUE_LLIMIT  format 32.19, VALUE_ULIMIT  format 32.19
from work2.Qin_refdata_test;
run;
quit;

/* 일반형태 수출입 및 상하위 범위 이내 자료에 대한 가중평균 단가 산출 */
PROC MEANS DATA=WORK2.QIN_REFDATA_TEST_op NOPRINT;
    CLASS HSCODE TIME;
    VAR VALUE_UPRICE;
    FREQ VALUE_QTY;
    ID EXP_CODE;
    TYPES HSCODE * TIME; /* HS_월별, HS_월_지역별 자료만 생성 */
    OUTPUT OUT=WORK.QIN_D3_TMP_TEST_OP MEAN=VALUE_MEAN;
    QUIT;
RUN;

proc compare DATA=WORK2.QIN_REFDATA_TEST COMPARE=WORK2.QIN_REFDATA_TEST_op
LISTALL;
VAR VALUE_MT VALUE_QTY DATA_VALUE VALUE_UPRICE VALUE_LLIMIT VALUE_ULIMIT;
RUN;