I have various values that I want to assign formats to. However, some of these values are substrings. For example, say I have the following: if AccountID = '2BCD' then Client = 'A'; else if AccountID = '2ACD' then Client = 'B'; else if substr(AccountID,1,3) = '2CD' then Client = 'C'; else if... So, instead of having a ton of if else statements I want to assign a format called $Client. to the variable Client. So, I would do the following: proc format; value $Client '2BCD' = 'A' '2ACD' = 'B' this is where I get stuck because I cannot simply say '2CD' = 'C' because it is only a substring of the AccountID.
... View more