You could also do everything in SAS, as suggested by Peter.L , in a fairly robust fashion : data test; length v1-v9 $24; infile datalines dlm=','; input @; _infile_ = prxchange("s/(\$\d+),(\d{3})/$1$2/o", -1, _infile_); input v1-v9; datalines; 11,1374,C5,37,24 to,286330.962000,10. >=$23,000 <$51,000 ,6553.3000,11 ; PG
... View more
