yes i have tried but not working data foo; length slurp $32000; retain slurp ''; input @; slurp=cats(of slurp _infile_); if not mod(countw(slurp,'|'),3) then do; do i=1 to countw(slurp,'|') by 3; name=input(scan(slurp,i,'|'),$32.); user=input(scan(slurp,i+1,'|'),$32.); no=input(scan(slurp,i+2,'|'),8.); output; end; slurp=''; end; drop slurp i; cards; ajay|ku mar|2656 muni|carr om|455676 ajay|kumar|9890|vijay|kumar|589|user|flow|568 ; run; This is ok but i wnat it with outcards to insert as i am having 70000 obs i cant insert ,can u create dataset fisrt and after that we can use the code data temp; infile cards missover truncover; input sclurp $32000. ; cards; ajay|ku mar|2656 muni|carr om|455676 ajay|kumar|9890|vijay|kumar|589| user|flow|568 run; data temp2; /*input @;*/ set temp; sclurp=cats(of sclurp ); retain sclurp ''; if not mod(countw(sclurp,'|'),4) then do; do i=1 to countw(sclurp,'|') by 4; name=input(scan(sclurp,i,'|'),$32.); user=input(scan(sclurp,i+1,'|'),$32.); no=input(scan(sclurp,i+2,'|'),8.); output; end; sclurp=''; end; drop sclurp i; run; proc print; run; as mentioned below i am trying by this way but i am not getting the output as getting ERROR as cards or infile is no there art can u help me in this. Thqs in advance
... View more
