Hi,
Any one can give '#' table code (example)
Thanks,
Suresh
Did you mean Hash Table ?
Yes please !
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.