SAS Support Communities

I am incredibly grateful and honored to receive the votes and the kind comment at the SAS Awards 2023. Your support and recognition mean the world to me, and I cannot express how much I appreciate it. To have my efforts acknowledged by peers and professionals in the industry is truly humbling. It motivates me to continue striving for excellence and pushing the boundaries of my work. Your vote of confidence gives me the confidence to pursue new challenges and opportunities with even greater enthusiasm. I would also like to extend my heartfelt gratitude for the thoughtful comment you provided. Your words of encouragement and appreciation serve as a reminder of the impact our work can have on others. It is through such positive interactions and connections that we are able to grow and inspire one another. Once again, thank you for your support, votes, and the kind comment. I am deeply grateful for the recognition bestowed upon me at the SAS Awards 2023. I will continue to work hard, learn, and contribute to the best of my abilities. With sincere appreciation, Daniel Wanjiru ... View more

Hi @djrisks , I want to extend my sincerest well wishes to you, on this deserving achievement. Your dedication and expertise in the field of graphs have made you an invaluable mentor. Whenever I find myself facing challenges with graphs, I can always count on you for guidance. Your willingness to assist, regardless of the complexity of the question, is truly commendable. Once again, I wish you the best of luck in your future endeavors. Your continuous support and mentorship are greatly appreciated.   Warm regards, Daniel Wanjiru ... View more

Hi @djrisks , I want to extend my sincerest well wishes to you, on this deserving achievement. Your dedication and expertise in the field of graphs have made you an invaluable mentor. Whenever I find myself facing challenges with graphs, I can always count on you for guidance. Your willingness to assist, regardless of the complexity of the question, is truly commendable. Once again, I wish you the best of luck in your future endeavors. Your continuous support and mentorship are greatly appreciated.   Warm regards, Daniel Wanjiru ... View more

Hi Kriss, I want to extend my sincerest well wishes to you, on this deserving achievement. Your dedication and expertise in the field of graphs have made you an invaluable mentor. Whenever I find myself facing challenges with graphs, I can always count on you for guidance. Your willingness to assist, regardless of the complexity of the question, is truly commendable. Once again, I wish you the best of luck in your future endeavors. Your continuous support and mentorship are greatly appreciated.   Warm regards, Daniel Wanjiru ... View more

data result; merge TEST_1 (in=in1) - TEST_100 (in=in100); by ID; If sum(of in1-in100) =100; run; Hope this works ... View more

data result; merge TEST_1 (in=in1) - TEST_100 (in=in100); by ID; if in1 and in100; /* ?*/ run; Another way using proc sql  PROC SQL; Create table result as Select * from test_1 as in1, test_100 as in100 where in.ID = in100.ID; Quit; Both codes will  returns rows common to both tables (data sets).  ... View more