DATA Step, Macro, Functions and more

# Table example

Reply
Frequent Contributor
Posts: 86

# Table example

Hi,

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

Thanks,

Suresh

Super User
Posts: 9,681

Re: # Table example

Did you mean Hash Table ?

Frequent Contributor
Posts: 86

Re: # Table example

Yes please !

Super User
Posts: 9,681

Re: # Table example

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

Ask a Question
Discussion stats
  • 4 replies
  • 210 views
  • 0 likes
  • 3 in conversation