Hi, I started learning SAS one week ago. I know some basics like data steps, loops, BY statement and how it creates First and Last variables, some Procedures like Sort. I have a dataset divided into groups, each group has different number of observations: example of how that dataset would look like: x y a 0 a 5 a 22 b 22 b 3 c 5 c 22 c 14 c 9 So in this case, 22 appears in 3 groups so the result will be 22. I just want to know the idea of how to implement that, I thought of comparing each observation for all other observations and so on, but this makes no sense in case if I have a big dataset.
... View more