2 0 40 table lookup application step 1 hardcode the

2 0

40
Table Lookup Application
Step 1: Hardcode the program, including customer name
and number.
proc print data=orion.order_fact;
where customer_ID=9;
var order_date order_type quantity total_retail_price;
title1 "Customer Number: 9";
title2 "Customer Name: Cornelia Krahl";
run;
m104d03a

41
Table Lookup Application
Step 2: Create and reference a macro variable for the
customer number.
How can you reference the customer name in TITLE2
without hardcoding it?
%let custID=9;
proc print data=orion.order_fact;
where customer_ID=&custID;
var order_date order_type quantity total_retail_price;
title1 "Customer Number: &custID";
title2 "Customer Name: Cornelia Krahl";
run;
m104d03b

42
Table Lookup Application
The orion.customer data set contains customer names
and ID numbers. Customer ID numbers are unique.
Orion.Customer Orion.Customer Orion.Customer Orion.Customer
Birth_ Birth_ Birth_ Birth_
Obs Customer_ID Customer_Name Country Gender Date Obs Customer_ID Customer_Name Country Gender Date Obs Customer_ID Customer_Name Country Gender Date Obs Customer_ID Customer_Name Country Gender Date
1 4 James Kvarniq US M 27JUN1974 1 4 James Kvarniq US M 27JUN1974 1 4 James Kvarniq US M 27JUN1974 1 4 James Kvarniq US M 27JUN1974
2 5 Sandrina Stephano US F 09JUL1979
2 5 Sandrina Stephano US F 09JUL1979 2 5 Sandrina Stephano US F 09JUL1979
2 5 Sandrina Stephano US F 09JUL1979
3 9 Cornelia Krahl DE F 27FEB1974 3 9 Cornelia Krahl DE F 27FEB1974 3 9 Cornelia Krahl DE F 27FEB1974 3 9 Cornelia Krahl DE F 27FEB1974
4 10 Karen Ballinger US F 18OCT1984 4 10 Karen Ballinger US F 18OCT1984 4 10 Karen Ballinger US F 18OCT1984 4 10 Karen Ballinger US F 18OCT1984
5 11 Elke Wallstab DE F 16AUG1974 5 11 Elke Wallstab DE F 16AUG1974 5 11 Elke Wallstab DE F 16AUG1974 5 11 Elke Wallstab DE F 16AUG1974
6 12 David Black US M 12APR1969 6 12 David Black US M 12APR1969 6 12 David Black US M 12APR1969 6 12 David Black US M 12APR1969
7 13 Markus Sepke DE M 21JUL1988 7 13 Markus Sepke DE M 21JUL1988 7 13 Markus Sepke DE M 21JUL1988 7 13 Markus Sepke DE M 21JUL1988
8 16 Ulrich Heyde DE M 16JAN1939 8 16 Ulrich Heyde DE M 16JAN1939 8 16 Ulrich Heyde DE M 16JAN1939 8 16 Ulrich Heyde DE M 16JAN1939
9 17 Jimmie Evans US M 17AUG1954 9 17 Jimmie Evans US M 17AUG1954 9 17 Jimmie Evans US M 17AUG1954 9 17 Jimmie Evans US M 17AUG1954
10 18 Tonie Asmussen US M 02FEB1954 10 18 Tonie Asmussen US M 02FEB1954 10 18 Tonie Asmussen US M 02FEB1954 10 18 Tonie Asmussen US M 02FEB1954
11 19 Oliver S. Füßling DE M 23FEB1964 11 19 Oliver S. Füßling DE M 23FEB1964 11 19 Oliver S. Füßling DE M 23FEB1964 11 19 Oliver S. Füßling DE M 23FEB1964
12 20 Michael Dineley US M 17APR1959 12 20 Michael Dineley US M 17APR1959 12 20 Michael Dineley US M 17APR1959 12 20 Michael Dineley US M 17APR1959

43
Table Lookup Application
Step 3: Add a DATA step to create a macro variable with
the customer's name. Reference the macro
variable in TITLE2.
%let custID=9;
data _null_;
set orion.customer;
where customer_ID=&custID;
call symputx('name', Customer_Name);
run;
proc print data=orion.order_fact;
where customer_ID=&custID;
var order_date order_type quantity total_retail_price;
title1 "Customer Number: &custID";
title2 "Customer Name: &name";
run;
m104d03c
same
statement