topic Re: Exclude a row from dataset in SAS in SAS Programming

Exclude a row from dataset in SAS

Daisy2 — Fri, 31 Jul 2020 18:43:34 GMT

Can you exclude a row in a dataset in SAS? I know you can do it in JMP but can't find anything about it in SAS.

If the only option is to delete, how do I delete a row with specific variables? For example, the two rows I want to delete have the following categorical variables. This combination of variables makes those rows unique.

Row 1: Loc = A, Hyb=X03, Ntrt = High, Density = Low

Row 2: Loc = B, Hyb = X04, Ntrt = Low, Density = Low

Thanks

Re: Exclude a row from dataset in SAS

AMSAS — Fri, 31 Jul 2020 18:55:34 GMT

Something like this:

Data want ;
 set have ;
 if loc="A" and Hyb="X03" and Ntrt="High" and Density="Low" then delete ;
 if loc="B" and Hyb="X04" and Ntrt="High" and Density="Low" then delete ;
run;

Re: Exclude a row from dataset in SAS

mklangley — Fri, 31 Jul 2020 19:35:37 GMT

proc sql;
    delete from my_dataset
    where (Loc = 'A' and Hyb = 'X03' and Ntrt = 'High' and Density = 'Low')
       or (Loc = 'B' and Hyb = 'X04' and Ntrt = 'Low' and Density = 'Low');
quit;

Or, if you just want to exclude those rows:

proc sql;
    create table want as
    select *
    from my_dataset
    where not (Loc = 'A' and Hyb = 'X03' and Ntrt = 'High' and Density = 'Low')
       and not (Loc = 'B' and Hyb = 'X04' and Ntrt = 'Low' and Density = 'Low');
quit;

Re: Exclude a row from dataset in SAS

Daisy2 — Fri, 31 Jul 2020 19:48:43 GMT

Thanks!