Thanks data_null. For the reply to the post. I am unable to view my post Its telling unauthorised access. Might be technical bug. Can u just clarify the steps infile cards col=c; input id :$3. @; call scan(_infile_,-2,s,l,' '); l=s-c-1; input name $varying64. l dob:mmddyy12. money :comma12.; format dob mmddyy10. money dollar12.; drop s l; How to import delimited space text file created by data_null_; in Data Management - View the full discussion data pita; infile cards col=c; input id :$3. @; call scan(_infile_,-2,s,l,' '); l=s-c-1; input name $varying64. l dob:mmddyy12. money :comma12.; format dob mmddyy10. money dollar12.; drop s l; list; cards; 001 Christopher Mullensc 11/12/1955 $45,200 002 Michelle Kwo 9/12/1955 $78,123 003 Roger W. McDonald 1/1/1960 $107,200 ;;;; run; proc print; run;