The SAS Training video clip demo below is a simple example of how to create a DI studio job and use the join transform to create an output data set and derive a new column.