@novinosrin  I know you have a very high standards set for yourself. But because of that, Novice SAS user can learn a bit more about hash function. I am in fact glad that you had posted for me to learn how it works.   Thank you so much!! 😄 ... View more

Do not split like data, you will just incur additional read/writes, store data in a larger form of disk (due to header block) and create messy unmaintainable code to try to handle it.  SAS has built in functionality to deal with this, its called by group processing, and it is quicker and simpler than anything you come up with.  As such this question is moot as you will not be doing this.   Next up, post test data in the form of a datastep: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 We cannot see your data and this is a key part in any SAS programming task, you say that is a number, is it numeric or text?  Where are you getting it from, what do you want to do with it?  Provide what manipulation you want to do (i.e. show input test data, and result) and we can provide code to do it.  ... View more

@hvempati wrote: Hi @Tom and @PeterClemmensen,   Do you think there would be a performance issue by using a method like this?   I was using a method where I was manually inputting all the dates. But now by using this method, I have seen the runtime for the same code was slow. (previously the code ran for 3 minutes, but now it runs for 10 minutes.) I haven't changed anything except this. Any inputs on this? Thank you.     There is no difference between running code like: select * from have where date = '2017-12-01' And the same code generated by using a macro variable. %let mvar='2017-12-01'; ... select * from have where date = &mvar If you are seeing a difference then either your data has changed or your query has changed. ... View more

Hi, @art297 Thank you for your reply. I had figured out that the input data I was giving was incorrect. ... View more