Duduplication accross rows

[novinosrin]

Good morning, Sure

[frupaul]

HI  Novinosrin,

Please can you recommend a book/journal/publication on Hash Object that can take me from beginner to pro?

Thanks,

Paul

[novinosrin]

Good morning @frupaul  Here it is

https://communities.sas.com/t5/Community-Matters/Book-Data-Management-Solutions-Using-SAS-Hash-Table...

Nothing /Nobody beats that book or Paul Dorfman. Do read that, you are the next Paul as your name already being paul with prefix fru will bear fruit.

By the way, I have just made it to my college lab as the morning trains were running late. I saw your other post and I noticed few responses. Since we both like hash, I will have a fun response with hash too in a bit

[FreelanceReinh]

Hi @frupaul,

The authors of the book @novinosrin has recommended are of course world-class SAS programmers and you can learn many SAS tricks from their long professional experience.

To get a taste of their writing style (and, above all, of the hash object) you could read their 2017 paper Beyond Table Lookup: The Versatile SAS® Hash Object, which is closely related to their book.

When I started learning hash object programming there was only Michele M. Burlew's book "SAS® Hash Object Programming Made Easy". In October 2016 I wrote a customer review (titled "Valuable resource for intermediate and advanced SAS programmers") about it on a very well known online bookseller's website.

As the hash object has become one of my must-have tools, I've recently purchased the PDF version of the Dorfman/Henderson book (as a sort of "next-level sequel").

[frupaul]

Thanks Guys,

I have now got hold of the book novinosrin  recommended. It is a simple read.

Can any of you recommend a book on do loops please?

Thanks

[FreelanceReinh]

Hi @frupaul,

I doubt that there is a book devoted to DO loops alone, but there are conference papers on this topic. Two prominent examples:

• http://analytics.ncsu.edu/sesug/2002/TU05.pdf (by Paul Dorfman)
• http://www2.sas.com/proceedings/forum2007/067-2007.pdf (by Ron Fehd)

[novinosrin]

@frupaul I believe you should get hold of Ron cody's Learning SAS by Example: A Programmer's Guide, Second Edition.

It is only safe to be aware  @FreelanceReinh's standards are among the  best in the world although his humility/modesty might not show that , but the reality for us folks (like you and I) is that  we might find the learning curve bit too steep to read Dorfman alike authors. Therefore, my sincere and humble suggestion is to start  learning with detailed examples portrayed in Ron cody's , then perhaps look into Art carpenter's book and beyond. HTH & Thank you!

[Ksharp]

data Hierarchy;
 INFILE DATALINES DLM='' missover;
 length CustID $10 L1 $20 L2 $20 L3 $20 L4 $20 L5 $20 L6 $20 L7 $20 L8 $20;
 input CustID  $ L1 $ L2 $ L3 $ L4 $ L5 $ L6 $  L7 $ L8 $;
 cards;
 1 James James Luke Tom Anthony Matthew Jake Brudhy
 2 Peter Peter Raymond Raymond Peter Luke
 ;
data want;
 set Hierarchy;
 array x{*} $ L:;
 array y{9999} $ 100 _temporary_;
 call missing(of y{*});
 j=0;
 do i=1 to dim(x);
   if x{i} not in y then do;j+1;y{j}=x{i};end;
 end;
 do i=1 to dim(x);
   x{i}=y{i};
 end;
 drop i j;
run;