Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Base Certification Training Course
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Base Certification Training Course
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Data Manipulation [6-18]
(Sample)


Data Set Concatenation
Picture
Data Set concatenation is to combine data sets one on top of another.

It can be done by simply using the SET statement.


Example
Picture
Data set: LIST1
Picture
Data set: LIST2

Both of the LIST1 and LIST2 data set contain the same set of variables:
  • SKU: Product ID
  • PRODUCT: Name of the product
  • QTY: Quantity available
  • Price: Price of the product

In order to analyze the complete set of data, we must combine the two data sets.

Example

Data List;
Set List1 List2;
Run;

Picture

The LIST1 and LIST2 are now combined into a new data set called LIST.


Exercise
​
Locate the PRDSAL2 and PRDSAL3 data sets from the SASHelp library. 

Concatenate the two data sets. Save the data set in the WORK library. How many observations are there in the combined data set?

Next

Need some help? 

Get Hint
Get Solution
Fill out my online form.
Already a member? Go to member's area.