Base SAS Programming - Lecture 6 (continued @
The first 6 lectures are posted free of cost. Remaining videos available at https://vimeo.com/ondemand/sasuma for paid subscription
Appending datasets – Proc Append – Force option – Merging datasets – Merge statement – In option - significance of sorting datasets before merging – Types of SAS Merges: Inner, Right Inner, Left Inner, Exact, Outer, Right Outer and Left Outer Merge- Conditions for different types of merges.
Types of merges
1. Inner Merge - All observations of both datasets -no condition
2. Exact Merge - Only the common observations between the datasets = x=1 and y=1 / if x and y.
3. Right Inner Merge - Observations of Right dataset only,y=1 / if y
4. Left Inner Merge - Observations of Left dataset only, x=1 / if x
5. Right Outer Merge - uncommon observations of Right dataset only, x=0 and y=1 / if not x and y
6. Left Outer Merge - observations present in left dataset but not in right dataset-uncommon observations, x=1 and y=0
7. Outer Merge - uncommon observations of BOTH datasets / x=0 OR y =0 / if not x OR not y
For more information on SAS and Analytics training, login to www.learnanalytics.in or drop a mail at [email protected]
New Training batches are started every two weeks.
