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.
... View more