proc sql noprint;
        create table temp as select
        deal_no, cust_no, kid, amount from &_input.;
    quit;

    data &_output;
        set work.temp;
    run;

    proc export data=temp file="&path_1"
    label dbms=dlm replace;
    delimiter=';';
    quit;