PROC SQL Practice Project

This project demonstrates important PROC SQL concepts used in SAS programming and Clinical SAS interviews.

Topics Covered

• SELECT
• WHERE
• ORDER BY
• GROUP BY
• HAVING
• INNER JOIN
• LEFT JOIN
• CASE WHEN
• Subqueries
• CREATE TABLE

Skills Demonstrated

• Data manipulation
• SQL joins
• Summary statistics
• Conditional logic
• Table creation