I have distributors that feature a number of products. Some only 1, but others up to 25. I'd like to scan all 25 columns and return if a distributor features that product The data is aligned as follows: Distributor_ID First_Product Second_Product......................................25_Product 1 Apples Bananas 2 Grapes 3 Bananas Grapes Kiwis etc etc In EXCEL it's dead easy using COUNTIF(array,value). So, I can create a new column in Excel for each Product. Since Distributor #1 sells Apples, a variable APPLES would have a value of 1 (vs 0) 1) What's the best way to handle this in SAS? 2) If the products were concatenated into a single variable, best way in that case? EX (Apples|Bananas) for Distributor_ID=1
... View more