Hi! I'm working on SAS Studio and I have a big data of almost 700,000 observations, and it looks something like that: _____________________________ ID a1 a2 a3 a4 ... a20 1 11 12 14 15 ... 2 11 13 . . ... 3 12 13 14 . ... 4 12 14 15 . ... ... 700000 .... _____________________________ (The numbers in the a's can be everything, but always a1<a2<a3<a4 etc.) as you can see, ID 1, ID 3 and ID 4 have the numbers 12 and 14 (not in the same variables),and ID 1 and 4 have 12 and 15 as well as 14 and 15. So the data I want is: ___________ A B freq 12 14 3 12 15 2 14 15 2 ___________ (I want to know how many pairs of numbers repeats in the data and their frequency) How can I do that? Thank you very much!
... View more