topic Re: select all the values of a variable that are not contained in the values of another variable by in SAS Programming

select all the values of a variable that are not contained in the values of another variable by obs

Sir_Highbury — Mon, 04 Jul 2016 16:11:20 GMT

Dear experts,

assuming the following data set "have":

data have0;
country="BU"; output;
country="JP"; output;
country="US"; output;
run;
data have1;
value_list="US_ UK _JP NW"; output;
value_list="US_ UK _JP NW"; output;
value_list="US_ UK _JP NW"; output;
run;
data have; merge have0 have1 ;run;

I would like to obtain the following one:

data want
country="BU"; output;
run;

which is the most short, understandable and elegant way?

Re: select all the values of a variable that are not contained in the values of another variable by

stat_sas — Mon, 04 Jul 2016 16:20:50 GMT

Please try this.

data want(keep=country);
set have;
if not find(strip(value_list),strip(country));
run;

Re: select all the values of a variable that are not contained in the values of another variable by

rogerjdeangelis — Mon, 04 Jul 2016 17:25:57 GMT

HAVE

data have0;
country="BU"; output;
country="JP"; output;
country="US"; output;
run;

/*
Up to 40 obs WORK.HAVE0 total obs=3

Obs    COUNTRY

 1       BU
 2       JP
 3       US
*/


data have1;
value_list="US_ UK _JP NW"; output;
value_list="US_ UK _JP NW"; output;
value_list="US_ UK _JP NW"; output;
run;

/*
Up to 40 obs WORK.HAVE1 total obs=3

Obs     VALUE_LIST

 1     US_ UK _JP NW
 2     US_ UK _JP NW
 3     US_ UK _JP NW
*/


WANT

Up to 40 obs WORK.WANT total obs=1

Obs    COUNTRY

 1       BU


SOLUTION

* if the list does not change;
data mrg;
     merge have0 have1;
     if index(valuelist,country)=0 then output;
run;quit;


Up to 40 obs WORK.MRG total obs=1

Obs    COUNTRY     VALUELIST

 1       BU       US UK JP NW