topic Re: modify existing hash object in SAS Programming

modify existing hash object

frisco — Tue, 01 Jun 2010 21:20:19 GMT

Hi, I am loading a hash table using a sas dataset. I need to modify the code so that only certain records are loaded. Am I correct in thinking that a hash iterator object is the way to go? Thanks in advance for your help.

Re: modify existing hash object

ArtC — Fri, 04 Jun 2010 03:22:51 GMT

The ITERATOR object allows you to control the ordered retrieval of information from the hash table. Loading the table is much more straightforward. From your question it sounds like you will want to load the table one record at a time. The beauty of the hash object is that hash table is independent of the incoming order.

There are some references to information at:
http://www.sascommunity.org/wiki/Hash_object_resources

Re: modify existing hash object

Patrick — Sun, 06 Jun 2010 08:02:18 GMT

Hi

If this is only about subsetting a dataset before you load it into a hash object then why not creating a view and then using this view for loading the hash table, i.e.

proc sql;
create view HashInput as
select
from
where ;
quit;

data lookup;
set ....
if _n_ =1 then do;
declare hash h1 (dataset:'HashInput'<,...>);
....
end;
....
run;

If you have to modify the hash table while iterating through the data then look up the add() and delete() methods of the hash object.

HTH
Patrick