sas example

%let tempfile=/.........../template.xlsx;
%let file_path=/.........../;
%let dirLib=WORK;

PROC IMPORT DATAFILE="&tempfile."
OUT=&dirLib..TEMPLATE
DBMS=XLSX
REPLACE ;
Sheet="List";
GETNAMES=yes;
quit;

data &dirLib..temp1;
set &dirLib..TEMPLATE;
if date1 < 20180102 then delete;
keep date1 Contract_code Contract_variety Contract_price Index_code;
run;

data &dirLib..temp2;
set &dirLib..TEMPLATE;
if date1 < 20180102 then delete;
keep date2 Index_type Spot_price;
run;

proc sql noprint;
create table &dirLib..final as
select a.date1, a.Contract_code, a.Contract_price, b.Spot_price from &dirLib..temp1 a inner join &dirLib..temp2 b on a.date1 = b.date2;
quit;

data _null_;
set &dirLib..final;
file "&file_path./final_repost.csv" delimiter=',' DSD DROPOVER;
if _N_ = 1 then do;
put 'DATE,CONTRACT_CODE,CONTRACT_PRICE,SPOT_PRICE';
end;

put DATE $ @;
put CONTRACT_CODE $ @;
put CONTRACT_PRICE $ @;
put SPOT_PRICE $ @;
run;