Hands-On SAS for Data Analysis

Proc SQL joins

While introducing you to SAS programming we looked at the structure of the Proc SQL query. Let's look at the various join options in SAS. We will try and create a basic join without imposing any conditions.

We will use the Class dataset used in previous datasets and the following Grade dataset:

Data Grade;Input ClassID $ Year Grade $;Datalines;A1234 2013 AA2323 2013 AB3423 2013 BB5324 2013 CC2342 2013 CD3242 2013 DA1234 2019 BA2323 2019 CB3423 2019 DB5324 2019 BC2342 2019 CD3242 2019 D;

The following code will produce a dataset that contains the yearly grades of the students found in the Class dataset:

Proc SQL;            Create Table Class_Grade As            Select *            From Class, Grade            ;Quit;

After executing the preceding code, the key to understanding ...