It will give you the answer if you only want to count the first CCO in each county. Try using CATX() instead and see if the results differ. CREATE TABLE SASCDC_2.Arias_skinny_dataset_for_viz AS SELECT DISTINCT Contact_Person_ID, Monitoring_Status, Status, ZIP_Code, County_, Designation, catx(" - ", CCO_1,CCO_2,CCO_3,CCO_4,CCO_5,CCO_6,CCO_7 ,CCO_8,CCO_9,CCO_10,CCO_11,CCO_12,CCO_13 ,CCO_14,CCO_15) as CCO FROM SASCDC_2.Arias_contact_zip_cco_zip WHERE Monitoring_Status ne "Marked for deduplication"; quit;
... View more