Delete n rows before and n nrows after an observation

[Yuna11]

Hi guys,

I want to delete the rows that have all "(,)", "(,)", "(,)" (i.e., row 10) and then if that's true, always delete row-4;  for example, in the table below, I want to delete row 6-10; 11-15; 16-20; 21-25. Any suggestions? 

Would something like below work? 

Data final2;set Final; if _1="(, )" and _2="(, )" and _3="(, )" then Delete="Y";run;
Data final2;
do i=0,1,2,3,4;
if delete="Y" then do p=_n_-i;
set final2 point=p;
delete;
end;
end;
stop;
run;

[Quentin · Accepted solution]

This looks like a report, not a dataset.  Did you create this table (using PROC REPORT, PROC TABULATE, or similar?)

It's probably a better idea to change the creation of the report, rather than read the report into a dataset and delete rows and then print it out.

[Yuna11]

Yes, it is a report. Thanks for your suggestion, I will try work on the creation of report then.