* Performing a Table Lookup Using a Composite Index;

data primary;



store loc item $ amount; * format amount dollar6.0;

--------------------------------------------------

1 233 DEBIT 350

1 233 DEBIT 550

1 735 DEBIT 650

1 735 DEBIT 250

1 233 CREDIT 450

1 233 CREDIT 300

2 222 DEBIT 20

2 222 DEBIT 10

2 444 CREDIT 775

2 444 CREDIT 995

2 399 CREDIT 1000

2 399 CREDIT 2500





data lookup;



store loc @7 storname $14. @22 city $15.

----------------------------------------

1 233 Lynn's Finest  St Thomas

1 735 Lynn's Finest  San Diego

1 234 Lynn's Finest  Orlando

2 222 Just 4 You     San Francisco

2 444 Just 4 You     New York

2 399 Just 4 You     Boston