This is good example of why you should always define your table structure and variables instead of letting SAS guess at what definition you intended based when you first reference the variable. Use the LENGTH or ATTRIB statement to define the variables. You can also assign INFORMAT to make the INPUT statement easier.
So in this case define the variables in the order you want and then on the INPUT statement read them in the order they appear in the raw data.
data want;
length id 8 name $20 incentive salary 8 ;
informat incentive percent. salary comma. ;
input id name salary incentive;
cards;
1 Ram 25,000 40%
2 XYZ 31,000 25%
3 ABC 42,000 46%
4 MMN 52,000 20%
;
... View more
