libname mylib 'P:\'; proc sql; create table Banking as select a.*, b.*, c.* from mylib.customer_promo_recode as a inner join mylib.customer_banking_info as b on a.Customer_ID = b.Customer_ID inner join mylib.customer_demographics_recode as c on a.Customer_ID = c.Customer_ID; quit; data Banking_Region; set Banking; /* No mylib. prefix needed */ Region = put(int(substr(put(Customer_ID, 8.), 1, 2)), 2.); /* Extract first two digits for Region */ keep Customer_ID Region Contact; /* Keep only necessary columns */ run; proc format; value $RegionFmt 10, 11 = "Region A" 12, 13 = "Region B" 14 = "Region C"; value $ContactFmt "cellular" = "Cell Phone" "telephone" = "Home Phone" "unknown" = "Other"; run; proc freq data=Banking_Region; tables Region*Contact / nocol norow nopercent; format Region $RegionFmt. Contact $ContactFmt.; run; why is var Region still empty