How to delete values from different variables from one dataset

[Jarot741]

Let me begin by saying I am just starting to learn how to program.

I have a good size dataset with 14017 observations and 375 variables.

There are 10 variables of interest where I want to delete different values (they are characters)

Variables are CONCPT1, CONCPT2, ans so forth until CONCPT10 and values are hundreds of different values (i.e. 32551, 32160, 38746, 21620 and so on).

I tried the IF then delete statement with success if I include one value such as:

data pd6; set pd5;

if CONCPT1 = '32551' then delete;

run;

However, I want to delete hundreds of values from different variables (CONCPT1 - CONCPT10) and when I try to include more I receive an error (missing an operator or an incorrect answer)

I tried including more values to the IF statement but the result is not accurate.  For example:

data pd6; set pd5;

if CONCPT1 = '32551' '32160' '38746' then delete;

run;

Please let me know if I can be of any help with more information.

Thanks,

JG

[saslove · Accepted solution]

You need an "IN" operator with comma in between.

data pd6; set pd5;

if CONCPT1 in ( '32551', '32160', '38746') then delete;

run;

[Jarot741]

Thank you so much!

[FreelanceReinh]

---

@saslove wrote:

You need an "IN" operator with comma in between.

data pd6; set pd5;

if CONCPT1 in ( '32551', '32160', '38746') then delete;

run;

---

Commas are not required, blanks are sufficient.

[Reeza]

You'll likely want to switch to arrays as well:
https://stats.idre.ucla.edu/sas/seminars/sas-arrays/

[Jarot741]

Thank you so much! I will look into it!