Find the string

[RAVI2000]

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

[Reeza]

Can you show what you tried with index?

[RAVI2000]

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

[Reeza]

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-differ...

A more complex one:

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

And one more:

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

[RAVI2000]

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.

[andreas_lds]

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;

[andreas_lds]

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.

[andreas_lds]

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.

[s_lassen]

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;