topic How to create a subset selecting multiple values from multiple variables in SAS Programming

How to create a subset selecting multiple values from multiple variables

ElisaC — Wed, 08 Jul 2020 19:51:27 GMT

I am using SAS 9.4. I want to subset my dataset to include only records containing certain values in at least one variable of a set of variables. I have 10 variables (var1-var10) containing values like A100 or B250. There are hundreds of different possible values and I only need records containing certain values.

I tried this code:

data abc.subset; set abc.dataset; array vars var1-var10; if 'A100' in vars ; run;

and it works with just one value (A100), but when I add more values:

data abc.subset;
  set abc.dataset;
  array vars var1-var10;
  if ('A100' or 'B250) in vars ;
run;

then the log returns a note saying: Invalid numeric data. How can I do this?

Thank you.

Re: How to create a subset selecting multiple values from multiple variables

smantha — Wed, 08 Jul 2020 20:03:20 GMT

data abc.subset;
  set abc.dataset;
  array vars var1-var10;
  if 'A100' in vars or 'B250' in vars ;
run;

'A100' or 'B250' returns 1 as both are non missing and then converts them into a character for comparison

Re: How to create a subset selecting multiple values from multiple variables

ElisaC — Wed, 08 Jul 2020 21:04:03 GMT

Thanks! It worked 🙂