topic Re: Delete data if not equal to specific informations in SAS Data Management

Delete data if not equal to specific informations

Giovani — Tue, 26 Dec 2017 16:56:41 GMT

Hi experts!!

For the data below I want to keep only the pieces of information where the Size(column) is equal to Compact, Medium_SUV, and Medium_size. Any thoughts how I can do that?

data Cars;

input Type $ Size $ Colour $;

datalines;

Car Medium_size Yellow

Car Small_size Blue

Car Small_SUV White

Car Compact White

Car Large_SUV Blue

Car Medium_SUV Gray

run;

Re: Delete data if not equal to specific informations

novinosrin — Tue, 26 Dec 2017 17:05:15 GMT

Do you mean, you only want to keep those obs where size in ('Compact', 'Medium_SUV','Medium_size')?

simple where or if statement?

where size in ('Compact', 'Medium_SUV','Medium_size');

if size in ('Compact', 'Medium_SUV','Medium_size');

Re: Delete data if not equal to specific informations

Astounding — Tue, 26 Dec 2017 19:40:03 GMT

Note that your sample program truncates the values down to 8 characters. You would need to add this statement before the INPUT statement:

length size $ 10;

You can use either an IF or a WHERE statement to subset, as was suggested. However, note that WHERE is not possible in your sample program, because you are inputting from raw data. WHERE is only permitted when the source of data is already a SAS data set.

Re: Delete data if not equal to specific informations

Giovani — Tue, 26 Dec 2017 20:34:34 GMT

Yes, I only want to keep the lines

where size in ('Compact', 'Medium_SUV','Medium_size');

Re: Delete data if not equal to specific informations

rvsidhu035 — Wed, 27 Dec 2017 15:45:12 GMT

data Cars;
length size $15.;
input Type $ Size $  Colour $;
if size in ('Compact', 'Medium_SUV','Medium_size');
datalines;
Car Medium_size Yellow
Car Small_size Blue
Car Small_SUV White
Car Compact White
Car Large_SUV Blue
Car Medium_SUV Gray
;
run;

Re: Delete data if not equal to specific informations

PeterClemmensen — Wed, 27 Dec 2017 18:40:32 GMT

data Cars;
  input Type $ Size $  Colour $;
  datalines;
Car Medium_size Yellow
Car Small_size Blue
Car Small_SUV White
Car Compact White
Car Large_SUV Blue
Car Medium_SUV Gray
  run;

data want;
   set Cars;
   where Size not in ("Compact", "Medium_SUV", "Medium_size");
run;

Re: Delete data if not equal to specific informations

Giovani — Wed, 27 Dec 2017 21:10:48 GMT

draycut you are fantastic!!!

this is the best solution!!!