topic Re: Selecting from group in SAS Programming

Selecting from group

bharani721 — Fri, 16 Dec 2016 23:53:25 GMT

Hi,

Please help me on this. I'm writing a SAS code to select from group of variables.

Sample data:

Store number Store list

----------------- ------------

2 (2,4,5)

3 (33,44,9)

10 (3,10,2)

35 (9,2,4)

12 (35,12,25)

I'm expecting a report as below:

i.e. 'Store number' present from 'store list'... 2 is present from (2,4,5) list and 10 is present from (3,10,2) and 12 from (35,12,25).

Re: Selecting from group

ballardw — Sat, 17 Dec 2016 00:00:58 GMT

Are these values in the same dataset? Different data sets? Is the "list" a single value as shown complete with commas and parentheses?

Re: Selecting from group

bharani721 — Sat, 17 Dec 2016 00:02:42 GMT

Both of them are present in the same dataset. yes, the list always in the same format with commas and parentheses like (2,3,4)

Re: Selecting from group

Reeza — Sat, 17 Dec 2016 01:59:30 GMT

You can use FINDW or INDEXW, make sure to specify the delimiters in the third paramter.

You can't use FIND() or INDEX() because 2 will be found in 12, 22, 23, etc.

data want;
set have;
x=put(find, 8. -l);
if findw(string, trim(compress(x)), '(),')>0 then output;
run;

Re: Selecting from group

bharani721 — Sat, 17 Dec 2016 03:18:53 GMT

Thanks much.. It worked perfectly!

Re: Selecting from group

Jagadishkatam — Sat, 17 Dec 2016 09:12:11 GMT

alternatively with do until

data want ;
set have;
i=0;
do until(scan(compress(Store_list,'()'),i,',') eq '') ;
i+1;
if compress(Store_number) eq scan(compress(Store_list,'()'),i,',') then output;
end;
run;