Sorry, here is a short example of my code. The first statement on the 'where; clause is the numeric 'DISTRICT' column. All others are character and work.
PROC SQL;
CREATE TABLE WORK.DATA_SELECTED AS
(SELECT
t1.DISTRICT,
t1.OFFICE_NAME,
t1.OFFICE_LOCATION
t1.OFFICE_MANAGER
t1.NBR_EMPLOYEES,
t1.COUNTY_NAME,
t1.ADDR_LINE_1,
t1.ADDR_LINE_1,
t1.CITY,
t1.STATE,
t1.ZIP
FROM mylib.t1 DISTRIC_INFO
WHERE t1.District = &NEW_district
and t1.Office_Name LIKE &NEW_OFFICE_NAME
and t1.State = &NEW_STATE
and t1.County_Name = &NEW_COUNTY
and t1.City = &NEW_CITY
and t1.Zip = &NEW_ZIP );
QUIT;
... View more