In this video, we discuss how to combine two or more similar tables vertically with duplicate records(Keeping all duplicate records).
Union all operator is used to join two or more tables vertically by column position not by column name, so common column in each select statement must be in the same order. It joins table vertically keeping all duplicate records.
• How does union operato...
@SASInsights: yt.sassolutions@gmail.com
Presented by: Dhruba Joshi
Негізгі бет How does union all operator work with proc sql || SAS Interview Question and Answer
Пікірлер: 2