topic Re: Find the string in SAS Programming

Find the string

RAVI2000 — Thu, 03 Feb 2022 23:42:02 GMT

Hello Everyone,

I have a variable cars which has 4 different values. Some records have multiple values in it(the dataset looks like one row by showroom). I want to create a dataset with multiple records where I want to search for the a particular string value and give it one row each(dataset looks like it has multiple records by showroom).

I tried using Index, but didn't give the desired result.

Thanks

Re: Find the string

Reeza — Fri, 04 Feb 2022 02:37:02 GMT

Can you show what you tried with index?

Re: Find the string

RAVI2000 — Fri, 04 Feb 2022 04:04:33 GMT

How do I divide the values for one showroom and put them into rows?
The Index really does't really helped.

Re: Find the string

Reeza — Fri, 04 Feb 2022 04:56:35 GMT

Here's a similar question, the answer is essentially the same except you have a different delimiter.

https://communities.sas.com/t5/SAS-Programming/Split-mixture-of-strings-separated-by-multiple-different/m-p/513303

A more complex one:

https://communities.sas.com/t5/SAS-Programming/re-Separate-String-into-seaparate-variables/m-p/772824

And one more:

https://communities.sas.com/t5/SAS-Programming/Creating-dummy-variables-from-variables-with-multiple-character/m-p/551781

Re: Find the string

RAVI2000 — Fri, 04 Feb 2022 05:16:19 GMT

data PD3;
	set PD2;
	
	if cars ne "" and index(compress(lowcase(cars)),"audionroad") then flag1 = "Audi on road";
	if cars ne "" and index(compress(lowcase(cars)),"benzonroad")then flag2 = "Benz on road";
	if cars ne "" and index(compress(lowcase(cars)),"hondaonroad") then flag3 = "Honda on road";
	if cars ne "" and index(compress(lowcase(cars)),"fordonroad") then flag4 = "Ford on road";
	if cars ne "" and index(compress(lowcase(cars)),"porche") then flag5 = "Porche";
	
run;

data PD4;
	group = 'A';
	do until(done1);
		set PD3(rename=(flag1=flag)) end=done1;
		output;
	end;
	
	group = 'B';
	do until(done2);
		set PD3(rename=(flag2 = flag)) end=done2;
		output;
	end;
run;

It is not giving what I want.

Re: Find the string

andreas_lds — Fri, 04 Feb 2022 06:42:44 GMT

If the screenshot shows what you want, then you need only one flag variable and use the output statement in each if.

if cars ne "" and index(compress(lowcase(cars)),"audionroad") then do;
  flag = "Audi on road";
  output;
end;

Re: Find the string

andreas_lds — Fri, 04 Feb 2022 06:50:09 GMT

Have you read the links posted by @Reeza ? The first one suggest a solution, so have a look at the documentation of the function countw and scan and the output statement, all combined with a loop solves your problem.

Re: Find the string

andreas_lds — Fri, 04 Feb 2022 06:51:00 GMT

Have you read the links posted by @Reeza ? The first one suggest a solution, so have a look at the documentation of the function countw and scan and the output statement. Used within a loop, your task can be solved in a single step.

Re: Find the string

s_lassen — Fri, 04 Feb 2022 10:26:06 GMT

Looks like your multiple cars are nicely separated by commas. So this may work:

data want;
  set have;
  do _N_=1 by 1;
    car=scan(cars,_N_,',');
    if car=' ' then leave;
    output;
    end;
  drop cars;
run;