Hi Soha,
Is your data an external file? maybe you can use @ functions:
data x(drop=z);
infile 'c:\xy.txt' dlm =' ' firstobs=2;
length x $8. y 8.;
input @1 x $ @;
retain z;
if indexc(x,'12345667890')=0 then do;
input @3 y;
z=x;
end;
else do;
x=z;
input @1 y;
end;
run;
... View more