Hi SAS Community, I had a question for you- I tried to look through to forums to see if something similar has been answered before but couldn't find anything- I apologize if it has! I'm completely new to SAS and have just been figuring things out as I go along and have run into a bit of a road-bump. I've posted the details below. So I have a dataset that looks like the following: Customer ID Year Supplier 12014 2001 88888 12014 2001 88888 22222 2002 88888 11111 2001 99999 41243 2003 99999 11111 2004 99999 41531 2004 88888 What I want to do is sum the number of unique customers that each supplier has by year, to get a database that looks like the following: Supplier Year # of Unique Customers 88888 2001 1 88888 2002 1 88888 2003 0 88888 2004 1 99999 2001 1 99999 2002 0 99999 2003 1 99999 2004 1 If a customer comes one year and again the next, they would count as unique. If they make multiple purchases in one year, they are not considered unique. I have really no idea how to get from the data I have to the data I want. Any advice would be much appreciated! Thank you.
... View more