Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL
Help

Chapter 1: Performing Queries Using PROC... > Summarizing Groups of Data - Pg. 17

proc sql; select salcomps.empid,lastname, newsals.salary,newsalary from sasuser.salcomps,sasuser.newsals where salcomps.empid=newsals.empid order by lastname;