Hello, I am trying to format a column which is defined as numeric but have character data. Details are as below: Length 3. Format FCLMS6A9. Informat 9.   Data Values: No Claims A00 0A0 5+ 3 4 00A 200 011   I want to format as : if 'No Claims' then 0; if '00A' then 1; if '011' then 2 etc   I tried PUT function, user defined format but nothing is working. Every time either SAS returns missing values or by default it converts 'No Claims' to 1, 'A00' to 7, '00A' to 5, '011' to 8, 200 to 13 etc.   Is there any way out? Thanks in advance.         ... View more