# Table example

[Grandhi4]

Hi,

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

Thanks,

Suresh

[chang_y_chung_hotmail_com]

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

[Ksharp]

Did you mean Hash Table ?

[Grandhi4]

Yes please !

[Ksharp]

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