Data Manipulation [6-18]
(Sample)

---

Data Set Concatenation

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

It can be done by simply using the SET statement.

Example

Data List1; Input Sku $ Product $ QTY Price; Datalines; S1290001 Laptop 50 979 S1290002 Laptop 30 632 S1290003 Desktop 100 1299 S1290004 Desktop 80 1599 S1290005 Laptop 10 2999 ; Run; Data List2; Input Sku $ Product $ QTY Price; Datalines; S1290006 Printer 300 229 S1290007 Printer 400 467 S1290008 Printer 100 899 S1290009 Cable 1200 8.99 S1290010 Cable 900 7.99 ; Run;

Data set: LIST1

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;

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

HINT:
Simply use the SET statement to combine the two data sets. Check the total number of observations in the Log window.

Get Solution

SOLUTION:
data prdsale;
set sashelp.prdsal2 sashelp.prdsal3;
run;

There are 34560 observations in the combined data set.

---

Fill out my online form.