Hi All, I've been struggling to write a neat code for some task but gets very cumbersome and complex each time. I have a data set like below. NAME Company INDUSTRY John A Finance John B finance John C information John D Insurance Mark … … Mark … … Whenever a person is present in two companies, there is a link between these two companies. What I am trying to compute is the number of links between a company with a company from same or another industry. For example, in the above, as long as John is present in Company A and B of finance, C of information and D of Insurance , I want to count 2 outside links and 1 inside link for A. So, my result should be something like this: Company Links outside industry Links inside industry A 2 1 B 2 1 C 1 0 D 1 0 I feel like I am missing some procs that might get my work to be done easier. Would some one please help me with the basic idea and Procs? Thanks a lot!
... View more