Hi,   I am not even sure if this is possible, so I would like to ask the experts. I have a dataset that looks like this:   Name  Location1  Loc2  Loc3  Loc4  Loc5 Sarah        A            B       A        A       A James       B            B       C        D       Albert        D            E       F               Rosie        E            E       E        A        A William     B            B        B        B       Ashley      D           D                          And I would like to know if each person visited ANY place (A,B,C,D,E,F) at least 80% of the times, at least 40% of the times etc. and which places.  Or percentages of visiting a single place for each person, for all locations highest percentage to lowest.   So the potential answer I would like to see would be something like this: (for each place) Name  Location_80%    Loc_40% Sarah        A                      A               (Since Sarah went to Location A 80% of the times but also 40% of the times) James                               B Albert Rosie                                E Rosie                                A        (not sure how this will work because Rosie went to E 60% of the times and A 40% of the times) William      B                      B Ashley       D                     D   Or something like this: Name   MostFrequentLocation  PercentageA    2ndMostFreqLocation    PercentB    3rdFreqLocation   PercentC Sarah               A                                80%                         B                          20%                        James              B                                50%                         C                          25%                 D                    25% Albert               D                                33.3%                      E                         33.3%                F                   33.3% Rosie               E                                60%                         A                          40% William             B                               100% Ashley              D                               100%   It might make sense to have frequencies next to each percentages...   Is something like this possible? New and infrequent user to SAS but I would really like to do this on my own. I have SAS enterprise guide.     ... View more

Hi all,   I'm trying to see if each person had visited different location for each observation and if there was a location they frequently visited.   The data looks like this (along with other variables like date, description of the visit...)   Name  Location Name1  location_A Name1  location_B Name1  location_C Name2  location_D Name2  location_D Name2  location_D Name2  location_E Name3  location_F Name3  location_G   So I would like to know if the people in my data set usually go to the same place (in the case of Name2 that went to location_B 75% of the time) or not (in the case of Name1 that went to three different places three different times).  Is there any good way to see this with a SAS code?   I know it's not a good data question, but I thought I would ask the experts anyways.   Thank you,         ... View more