Thanks Art!  OS2Rules, the link Art sent you is the way to go. There may be a slight delay when you change your email address in your profile to when it populates the community - if you run into anything just send me a message and I'll check it out.. ... View more

Thank you, that's help me a great deal. ... View more

Hi Andrew, LainieH here.  Your new blog URL for Heuristic Andrew is now up- to-date at http://www.sasCommunity.org/planet. Your work and contributions on http://sasCommunity.org and this support community https://communities.sas.com/people/AndrewZ/content are very valuable. Thank you for using SAS. Thank you also for accepting my apology about the blog feed. Merry Christmas to you , too Lainie ... View more

Thank you Xia. ... View more

Hi - I just unmarked your answer per your request and marked the one directly above as helpful - is that correct? ... View more

When I run that I get 0 records, regardless of whether the catx statements use '  ' or ' '. With two spaces (as in your posts) it shouldn't work at all, regardless, but I get 0 records either way. ... View more

.... I have the situation modified a little bit. I want to retain the key product combination from only if a a key is missing in particular week ... View more

Hi Xia Keshan, Yes, in the current example it is only two, but this was just for simplification. In my current data the number of groups and repetitions (k) vary but I was able to extend the code of RW9 (by including additional do loops) to accommodate my settings. I believe the same can be done with your code. Thanks to the both of you (Keshan and RW9), you've been very helpful! ... View more