topic Delete n rows before and n nrows after an observation in SAS Programming

Delete n rows before and n nrows after an observation

Yuna11 — Wed, 18 May 2022 02:07:54 GMT

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;

Re: Delete n rows before and n nrows after an observation

Quentin — Tue, 17 May 2022 20:40:07 GMT

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.

Re: Delete n rows before and n nrows after an observation

Yuna11 — Wed, 18 May 2022 01:29:13 GMT

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