Before continuing with this section, you should understand the concepts that are
presented in the following sections:
• Chapter 4, “Starting with Raw Data: The Basics,” on page 51
• Chapter 6, “Starting with SAS Data Sets,” on page 91
• Chapter 19, “Merging SAS Data Sets,” on page 289
• Chapter 20, “Updating SAS Data Sets,” on page 317
Input SAS Data Set for Examples
This section looks at examples from an inventory tracking system that is used by a tool
vendor. The examples use the SAS data set INVENTORY as input. The data set contains
is a character variable that contains a unique value that identifies each item.
is a character variable that contains the text description of each item.
is a numeric variable that contains a value that describes how many units of each tool
the warehouse has in stock.
is a numeric variable that contains the SAS date value that is the day for which
InStock values are current.
is a numeric variable that contains the price of each item.
The following program creates and displays the INVENTORY_TOOL data set:
input PartNumber $ Description $ InStock @17
ReceivedDate date9. @27 Price;
format ReceivedDate date9.;
K89R seal 34 27jul2010 245.00
M4J7 sander 98 20jun2011 45.88
LK43 filter 121 19may2011 10.99
MN21 brace 43 10aug2012 27.87
BC85 clamp 80 16aug2012 9.55
NCF3 valve 198 20mar2012 24.50
KJ66 cutter 6 18jun2010 19.77
UYN7 rod 211 09sep2010 11.55
JD03 switch 383 09jan2013 13.99
BV1E timer 26 03aug2013 34.50
proc print data=inventory_tool;
336 Chapter 21 • Modifying SAS Data Sets