I am trying to generate a 1% random sample from my data set, but I only want 1 of each distinct value in a variable. For example, if I have a set that looks like:   Company Name        Project Number        Joint Company CompA                       553                          CompX CompA                       552                          CompY CompB                       133                          CompZ   In my random sample, I would only want CompA chosen once, not multiple times due to being in multiple rows. So, I need a 1% random sample using variable CompName. In addition, I do not want it to produce a new data set. Instead, I want a new variable created (let's say, "Random"), where a value of 1 means that row was selected for the random sample, and '.' or '0' means it was not selected.   Does that make sense? I have tried both proc surveyselect and proc sql and cannot 1) get distinct values instead of duplicates and 2) generate a new column in the same data set (or even a new data set that has all the original variables in it).    Thank you for your help! ... View more

I'm trying to create a table that calculates the top 10 companies based on the number of unique clients they have. I have a CompanyName variable, a ClientID variable, and a ProjectID variable, so there are, for example, 10 observations for Company ABC  because they have 6 client IDs they are working with for a total of 10 different projects (so some of the clients are repeated but I only want to count each unique client). I am not trying to calculate projects, just the number of unique clients for each company and then sorting by the company with the most clients to create the top 10 list.    My data set looks something like: CompName.          ClientID.              ProjectID CompanyABC.         123                      0022 CompanyABC          123                      0023 CompanyABC           235                     0042 CompanyDEF          152                      0074 ...   Ultimately, I want something along the lines of:   Company     Client Count CompABC         2 CompDEF          2 CompXYZ          1...   I have tried proc summary, report, print, frequent, and sql...I can't seem to get a table that has more than the first observation (which is not even one of the "top" companies).    Any help is much appreciated! ... View more