Delete data if not equal to specific informations

[Giovani]

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;

[novinosrin]

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');

or 

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

[Giovani]

Yes, I only want to keep the lines 

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

[Astounding]

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.

[rvsidhu035]

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;

[PeterClemmensen · Accepted solution]

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;

[Giovani]

draycut you are fantastic!!!

this is the best solution!!!