data finaldata; set rawdata; Ac_Num=trim(scan(my_data,1,'|')); *scan(variable name, position, delimeter); Fr_Nm=trim(scan(my_data,2,'|')); Ls_Nm=trim(scan(my_data,3,'|')); Address=trim(scan(my_data,4,'|')); City=trim(scan(my_data,5,'|')); State=trim(scan(my_data,6,'|')); Text=trim(scan(my_data,7,'|')); run;
... View more
