That's straightforward: data want; attrib var1 format=$200.; infile datalines; input var1 $; datalines; 182-04-7814ASPDEN530 302-57-5023ATWOOD480 123-89-8470BROSNAN560 152-64-0014BROSSO780 813-63-7456CUTCHINS790 186-79-3143HOLERBACH670 ; run; Though I presume you mean you want to read it in as separate variables? If so post process it, here is a quick example, you just need to do substrings and chop it up (or use perl regular expressions). data want; set want; attrib first_string second_string format=$20. lastnum format=best.; first_string=substr(var1,1,10); lastnum=input(reverse(substr(reverse(strip(var1)),1,3)),best.); second_string=substr(var1,11,length(strip(var1))-3); run;
... View more