libname stock excel "Z:\Downloads\Sheet1.xls";
data stock;set stock.'Sheet1$'n;
rename _COL0 = code
_COL1 = name
_COL2 = date
_COL3 = price
_COL4 = rate
;run;
libname stock clear;
proc sort data = stock;
by code date;
run;
data del;set stock;
by code;
retain closing_count;
if first.code then closing_count = 0;
if price = . then closing_count+1;
if closing_count = 6 then output;
run;
proc sql;
create table stock_select as
select * from stock
where code not in (select code from del)
;quit;