1# waitalone11
Use the scan function and start from left.
HTH
data tmp;
length city $30 state $2 zipcode $5 addressdate salary 8;
infile cards;
input;
salary=input(scan(_infile_, -1, ' ' ),dollar10.2);
addressdate=input(scan(_infile_, -2, ' ' ),mmddyy10.);
zipcode=scan(_infile_, -3, ' ' );
state=scan(_infile_, -4, ' ' );
city=scan(_infile_, 1, state );
cards;
Chain of Lakes MN 55099 09/03/1988 $68,090.43
Pleasantville MN 55127 04/30/2000 $54,398.33
Rivertown MN 55999 05/24/1995 $83,729.98
Chain of Lakes MN 55099 03/15/1997 $57,928.54
Roseville MN 55100 02/28/1994 $43,231.78
St. Croix MN 55000 07/15/1990 $45,938.76
Roseville MN 55100 04/02/1997 $39,727.23
Roseville MN 55100 08/30/1999 $42,039.39
;
proc print;run;