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;
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.