While I have been working on the final topic(s) for the Data Steps section of the SAS course on the FILE & PUT statements, I have read a number of questions on the web about PROC SQL syntax. I was not going to start this section until somewhat later, but I have decided to publish the first few topics to explain some of the most useful PROC SQL syntax, so look out for the following topics in the next few weeks:
- SELECT & FROM
- ORDER BY
- GROUP BY & HAVING
- Joins, WHERE & ON
- INTO
- DISTINCT
- Summary functions
The SAS course topics can only be accessed by Programmer level members, but Free members can read the SAS course – Home page.