Reg: Comma and Quotes data want(keep=temp); infile 'c:\Raw_Data.txt' eof=last lrecl=32767; length temp _temp $ 32767; retain temp _temp; input; temp=compbl(cats(temp,_infile_)); if countc(temp,'",')ge 10 then do;temp=_temp;output;temp=compbl(_infile_);end; _temp=temp; return; last: output; run; data want3(keep=var:); set want3; array _v{10} $ 800 var1-var10; do i=1 to 10; _v{i}=scan(temp,i,'",','m'); end; run; Used this code but i am having another new data having codes and comma as delimiter with 10- variables and the data is having another problem that data is moving in to 2-3 lineslines in the exampe given line2,3 has the data for 10 variables only but moving to another line. "acv","1000036513","","Te_ADDR","507 Main, PLAZA, BUDH MARG","","HYd","","","IN" "acv","1000036513","","Te_ADDR", "507 Main, PLAZA, BUDH MARG","","HYd","","","IN" "acv","1000036513","","Te_ADDR","507 Main, PLAZA, BUDH MARG","","HYd","","","IN" "acv","1000 036513","","Te_ADDR","507 Main, PLAZA, BUDH MARG","","HYd","","","IN"
... View more