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;