Online File

How to use this page

---

Rick Aster: Professional SAS Programming Shortcuts: Contents

Chapter 53
Program
State capital hash lookup

---

DATA WORK.OUTER (DROP=RC);
   IF _N_ = 1 THEN DO;
      DECLARE HASH STATECAPITAL(DATASET: 'MAIN.CAPITALS', ORDERED: 'A');
      STATECAPITAL.DEFINEKEY('STATE');
      STATECAPITAL.DEFINEDATA('STATE', 'CAPITAL');
      STATECAPITAL.DEFINEDONE();
      END;
   SET WORK.LOCATE;
   RC = STATECAPITAL.FIND();
   IF RC THEN DO;
      CAPITAL = '';
      END;
   IF CAPITAL NE CITY;
RUN;