The SAS Training video clip demo below is a simple example of how to use the join transform, apply a where-clause and create an output data set.