전산Tip/SAS

[SAS] 소스파일 text infile하기

모던아트 2011. 2. 23. 15:50
반응형


RSUBMIT;
%MACRO TXT_INFILE(P_CORP, P_MODEL, P_FILE);
DATA    DT_RULE_&P_CORP._&P_MODEL;
        CORP = "&P_CORP";
        MODEL = "&P_MODEL";
        INFILE "&P_FILE";
        LENGTH  SCRIPT    $1000.;
        INPUT   SCRIPT 1-1000 @@;
RUN;

%ORA_TBL_UPLOAD(WORK.DT_RULE_&P_CORP._&P_MODEL);
%MEND;
ENDRSUBMIT;


RSUBMIT;
%TXT_INFILE(SC3, M09, C:\Documents and Settings\sassrv\My Documents\My SAS Files\9.2\DT_RULE\SC3_M09.TXT);
ENDRSUBMIT;