Tips:Macro Language Formatted Look-up
proc format; value $sitecode "KETCHIKAN" = 'A_KTN_' "POW" = 'B_POW_' "PETERSBURG" = 'C_PTG_' "YAKUTAT" = 'H_YAK_' other = 'UNK '; run; %let site = POW; %* Just an example in this code snippet; %let code = %sysfunc(putc(&site,$sitecode.)); %put &=code;
The use of formats to perform table look-ups is very common in the DATA step.
Did you know that you can also use formats in to perform table look-ups in the macro language?