Hey guys, thanks for the time, So not to confuse you, i will try to explain my issue. I have a table that contains information about clients and i would like to choose the store with maximum purchases for each client Client_ID Store Purchases 1 3 2 1 5 4 1 4 3 2 5 3 2 7 5 2 6 5 3 3 8 3 5 2 3 4 1 4 5 2 4 7 3 4 6 1 5 3 2 5 5 3 5 4 1 6 5 1 6 7 2 6 6 5 7 3 4 7 5 3 7 4 5 8 5 2 8 7 3 8 6 1 So, for the example above, i need to choose the store with the maximum purchases for my client. I don't think i can use "top with ties" which seems to be the solution if i were using T-SQL but since my data are stored on SAS EG, i cannot do so. Ideas, please?! ... View more

Hi, I am a noob concerning SAS programming. I came across a clustering method that i am applying to some sample data. I need a macro to contain a list of variable names and each time i call it it brings them, like a vector of some sort. Anyone keen on macro programming? Here is the pdf i found with the clustering technique(http://support.sas.com/resources/papers/proceedings13/068-2013.pdf), in page 4 it says : "The macros all_name and sm_name refer to the list of the variables of product frequencies and the corresponding list of variables to be standardized (preceded by SM_), respectively" Any help is welcome. Thank you. Gd day to ye ! ... View more