topic Re: Subsetting: If _ then delete, else don't do anything in SAS Programming

Subsetting: If _ then delete, else don't do anything

SasStatistics — Mon, 07 Jun 2021 18:53:04 GMT

I hope it is clear what I want to do without code:

I have a date set, and if one condition is true then I want to delete that row. If it is not true, then I don't want to do anything with the data, just let it be what it is.

How could I achieve this?

Thanks.

Re: Subsetting: If _ then delete, else don't do anything

Kurt_Bremser — Mon, 07 Jun 2021 19:02:35 GMT

Just like you wrote it:

if /* condition */ then delete;

Re: Subsetting: If _ then delete, else don't do anything

mklangley — Mon, 07 Jun 2021 19:28:25 GMT

Here's a simple example, just to illustrate:

data have;
    input name $ age;
    datalines;
Allen 12
Bob 23
Charles 34
Doug 45
Edward 56
    ;
run;

title 'Before:';
proc print data=have; run;

data want;
    set have;
    if name = 'Bob' then delete;
run;

title 'After:';
proc print data=want; run;

Re: Subsetting: If _ then delete, else don't do anything

Tom — Mon, 07 Jun 2021 19:34:10 GMT

To use with a subsetting IF just invert the test.

   if name = 'Bob' then delete;

is the same as

   if not (name = 'Bob') ;