The SAS Data Studio product does provide the 'join' transform as well as a 'calculated column' transform. For this scenario though, I am not sure that 'calculated column' transform would suffice as this transform supports calculation of column in form: <column> = <expression>;
Data Studio also provides the 'code' transform which could be used for this use case. Logic could be added such as if/else or select statement to create column.
Documentation for SAS Data Studio to create custom code: SAS Data Studio 2.2 - Create Custom Code
... View more
