Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

This sample works in SAS 9.1.3 and SAS 9.2

This behavior can be modified in SAS 9.2 with the use of the MULTIDATA argument on the DECLARE statement. See sample 34757

For additional information, click on the link below.

SAS 9.2 Language Reference: Concepts, Using DATA Step Component Objects.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

/* Create sample starting data */

data test;
  input key1 key2 data1;
datalines;
1 1 11
1 1 22
1 2 12
1 2 122
;

/***************************************************************************/
/* Duplicate KEY values are not allowed with hash objects.  WORK.TEST does */
/* have duplicates for KEY1 and KEY2, so in this case, only the first      */
/* occurrence of each key value will be loaded into the hash table H.      */
/***************************************************************************/ 
 
data nodups;

  /* On the first iteration of the data step declare and instantiate the  */
  /* hash object H.  Use the argument_tag DATASET: to load WORK.TEST into */
  /* H.  Define KEY1 and KEY2 as key variables for H and store DATA1 as   */
  /* data in H.  CALL MISSING initializes the DATA set variables KEY1,    */
  /* KEY2 and DATA1 to missing to avoid 'variable uninitialized' notes in */
  /* the log.  An assigment statement would work as well.                 */   
  if _n_ = 1 then do;
    dcl hash h(dataset:'work.test');
    h.defineKey('key1', 'key2');
    h.definedata('data1');
    h.defineDone();
    call missing(key1, key2, data1);
    end;

  /* Assign values to the data set variables KEY1 and KEY2 */
  key1=1;
  key2=1;

  /* Use the FIND method to locate matching KEY1 and KEY2 values in */
  /* the hash object H.  A zero result indicates a match was found. */
  rc=h.find();

  /* Use the NUM_ITEMS attribute to assign the number of items in the */
  /* hash object H into the data set variable TOTALITEMS.             */
  totalitems = h.num_items;

  /* Write the values of DATA1 and TOTALITEMS to the log. */
  put data1=; 
  put totalitems=;
run;


/************************************************************************/
/* In this sample KEY1, KEY2 and DATA1 are defined as keys.  Note DATA1 */
/* has 4 unique values so this time the hash object will have 4 items.  */
/************************************************************************/

data dups;
  if _n_ = 1 then do;
    dcl hash h(dataset:'work.test');
    h.defineKey('key1', 'key2', 'data1');
    h.defineDone();
    call missing(key1, key2, data1);
    end;
  totalitems = h.num_items;
  put totalitems=;
run;

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

OUTPUT from WORK.NODUPS 

data1=11
totalitems=2


OUTPUT from WORK.DUPS 

totalitems=4

Operating System and Release Information