SAS Proc SQL

Proc SQL overview

Get Started. It's Free
or sign up with your email address
Rocket clouds
SAS Proc SQL by Mind Map: SAS Proc SQL

1. Basic Options

1.1. Create One Table: Select

1.2. Create Tables: Union/ Left join/ right join/ Full join

1.3. Macro: Select : into

2. Common Options

2.1. Distinct

2.2. Where/ Having

2.3. Max/ Min/ Sum/ Count/ Group by

2.4. Order by/ sort by

2.5. Case when ... end

2.6. Substr/ concat/ Split

3. Advanced Options

3.1. Percentile

3.2. to_date/datediff

3.3. row_number()