topic Re: How to delete values from different variables from one dataset in New SAS User

How to delete values from different variables from one dataset

Jarot741 — Thu, 22 Nov 2018 20:33:18 GMT

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,

Re: How to delete values from different variables from one dataset

saslove — Thu, 22 Nov 2018 20:48:06 GMT

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

data pd6; set pd5;

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

run;

Re: How to delete values from different variables from one dataset

Reeza — Thu, 22 Nov 2018 20:51:52 GMT

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

Re: How to delete values from different variables from one dataset

Jarot741 — Fri, 23 Nov 2018 05:26:13 GMT

Thank you so much!

Re: How to delete values from different variables from one dataset

Jarot741 — Fri, 23 Nov 2018 05:26:55 GMT

Thank you so much! I will look into it!

Re: How to delete values from different variables from one dataset

FreelanceReinh — Fri, 23 Nov 2018 09:33:09 GMT

@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.