topic Searching Within a Concatenated Variable in SAS Programming

Searching Within a Concatenated Variable

DLF22 — Thu, 30 Apr 2020 04:49:10 GMT

Hi,

I am very new to sas an trying to search within a concatenated var ("COMBINATION") which is in the form (product1 + product2 + product 3) for any part of the previously used combination. I am trying to establish how many changes in combinations are a complete change (vs an addition to an existing regimen);

data completley_new_products;

set combination_products;

by cust_id combination;

lag_combination= lag(combination);

where combination not contains lag_combination;

run;

Any help or guidance much appreciated!

Re: Searching Within a Concatenated Variable

andreas_lds — Thu, 30 Apr 2020 05:12:29 GMT

It is not clear what you have and what you expect as result. So please follow the guidelines and include data in usable form, see How to convert datasets to data steps for details.

Re: Searching Within a Concatenated Variable

s_lassen — Thu, 30 Apr 2020 09:08:19 GMT

You will probably have to split the new combination into the various product codes, and check them one by one, something like:

data completely_new_products;
  set combination_products;
  by cust_id combination;
  lag_combination= lag(combination);
  if not first.cust_id then do _N_=1 to countw(combination);
    if indexw(lag_combination,scan(combination,_N_)) then
      delete;
    end;
run;