queirozfcom

data mytable;
    length name $20.;
    input id name $ balance; 

DATALINES;
1 alice   5.12  
2 bob  12.31
3 charlie 45.14
4 daniel 32.78
4 ella 20.23

queirozfcom

data mytable;
	
    input id= name=$12. balance= state=$2.; 

DATALINES;
id=1 name=alice balance=5.12 state=NE
id=2 name=bob  balance=12.31 state=SC
id=3 name=charlie balance=45.14 state=NY
id=4 name=daniel balance=32.78 state=
id=5 name=alice balance=20.23 state=WA