Pasting text as pictures makes it very hard to read.
You define table aliases using different two letter abbreviations than the aliases you use in the WHERE clause.
Your ON clause has a typo: It shouldn't be on sc.SIN=ct.SIN, but ON ST.SIN=CT.SIN
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.