How can I select a group of observations by facility for each ID?

[novinosrin]

Hi @Amanda3   You are not alone. Join our club of learners. Btw, The purpose of this message is to let you know there is an amazing book by @hashman  and @DonH  that covers all these topics. If and when you are interested, you may consider buying a copy from SAS Press or Amazon at some point. I have my university paid subscription to E-library safari-online. 

Data Management Solutions Using SAS^® Hash Table Operations: A Business Intelligence Case Study 

By Paul Dorfman(Hashman) and Don Henderson

I believe @ShelleySessoms  still is part of SAS press or can give you great leads regarding what's on offer, available discounts if any and so on. 

@Guru, do you wanna add a couple of points to get new OP's ease into learning higher advance techniques in utilizing the book in the best way? You know what I mean 🙂 When i used your solutions at Citizens citing your reference, my team mates and fellow teams ran away hahahaa. So basically prerequisites needs before reading the book can help new folks not feel intimidated and enjoy reading and learning in their own pace.  

[DonH]

Thanks for the kinds words @novinosrin.

And @Amanda3 if you are not ready to buy a book, you might want to consider reviewing the articles that Paul and I (and others) have written related to the book. Just search the communities library using the tag DMHashBook.

[ShelleySessoms]

Thanks, @novinosrin. I used to be part of SAS Press, now strictly communities but still have great friends in SAS Press. Customers will find all the deals and discounts on books available at https://support.sas.com/en/books.html

[hashman]

@novinosrin:

I cannot thank you enough for the enthusiastic support of our opus since before it was even published, so let me add another thank you to what @DonH has already expressed.

Kind regards

Paul D.