topic Re: # Table example in SAS Programming

# Table example

Grandhi4 — Fri, 11 May 2012 17:30:28 GMT

Hi,

Any one can give '#' table code (example)

Thanks,

Suresh

Re: # Table example

chang_y_chung_hotmail_com — Fri, 11 May 2012 18:15:15 GMT

https://communities.sas.com/message/search.jspa?peopleEnabled=true&userID=&containerType=&container=&q=dcl+hash

Re: # Table example

Ksharp — Mon, 14 May 2012 07:22:32 GMT

Did you mean Hash Table ?

Re: # Table example

Grandhi4 — Tue, 15 May 2012 06:18:53 GMT

Yes please !

Re: # Table example

Ksharp — Tue, 15 May 2012 07:10:23 GMT

There are lots of example at this Forum , search it you will get answer.

This example maybe too difficult for you . The code is used to split table.

data l;
input name $  age;
cards;
q    1
.    . 
e    3
.    .  
r    7
.    .  
w    6
;
run;
data _null_;
if _n_ eq 1 then do;
 if 0 then set l ;
 declare hash ha1(ordered:'a');
 declare hiter hi1('ha1');
 declare hash ha2;
  ha1.definekey('name','age');
  ha1.definedata('ha2');
  ha1.definedone();
end;
set l end=last;
if ha1.find()=0 then ha2.add();
 else do;
        ha2=_new_ hash(multidata:'y');
         ha2.definekey('name','age');
         ha2.definedata('name','age');
         ha2.definedone();
         ha2.add();
         ha1.add();
       end;
if last then do; n=-1;
               do while(hi1.next()=0);
                n+1;
                if n ne 0 then ha2.output(dataset: cats('l',n));
               end;
             end;
run;

Ksharp