Many many thanks @Reeza !   -- Dr. Abhijeet Safai ... View more

Many thank @Reeza !   - Dr. Abhijeet Safai ... View more

@PaigeMiller , many thanks! ... View more

@SASKiwi Many thanks!   What I require is very simple. When I double click the file, it should directly open in SAS. But somehow it is taking long long time to understand this new environment and still the problem is not solved. I will go through the link you have shared in detail shortly and will share the outcome here. I will close this topic once the solution is found but till now no solution has been found. I will share the requirement once again - When I am double clicking the file of SAS, I want it to open directly into SAS and not SAS universal viewer. I mean I want SAS 9.4 as the default programme to open it and not SAS Universal Viewer.    Many thanks once again.    -- Dr. Abhijeet Safai ... View more

Many many thanks @ballardw !   -- Dr. Abhijeet Safai ... View more

@Nigel_Pain , many thanks for the suggestion and as a result I will keep going in this direction. Somehow the files mentioned by you does not work. I mean when I gave that as an application to open the file, it got opened but the contents are missing. I tried one more option which is in the same folder, but that is also not working. But I am sure I will find out the answer soon. Many thanks for giving direction.   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Yes, I am aware of that, but I am not able to see the option of SAS in the alternatives. I want to know how to find it when no such option is seen. It is there somewhere but I want to know the exact filename and path which I should refer to. Thanks.   - Dr. Abhijeet Safai ... View more

@PaigeMiller , Thanks for the response.   Somehow that is not working. I tried it. I thought it will work but it is not working. We are accessing files on OneDrive and maybe there is issue with that. I do not understand much technical details in it but it is OneDrive which we are using for it.    Also, I am in search of a solution by following which the files will open in SAS 9.4 if I will double click it. I think there must be some solution in this direction.    Many thanks once again for your response.   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

This was very useful @ed_sas_member , many thanks!   - Dr. Abhijeet Safai ... View more

Not "j" but "I" works for informat. Many thanks @Ksharp !   I am replying to my own post for the purpose of documentation.  What a wonderful feeling it is to find out your own post some months back and finding answer in it next time when you search about it on the google! 🙂 ... View more

Is it valid to create a small randomized sample of cases and controls and then do a smaller sample of 1:2 matching from these randomized smaller samples?  In fact that is what I would suggest. Create a dummy dataset like the one which you have with you. Write programme for this small dummy datasets of having some thousand records or so. Run the programme on this dummy dataset. Make modifications with the help of statisticians until you and they feel that the programme is accurate. Once the programme is accurate and is doing what it is intended to do, run the programme on 10% of this big dataset by limiting the number of observations by using obs = option. Only then run the programme for the whole big dataset.    Now when you are running the programme on big dataset and also modifying the programme at the same time, lot of time is getting wasted because to make even a small change and to see if the change has taken effect, you have to wait for long time.    Once the programme if perfect and it is run for the large dataset, relax and grab your coffee and do something else. Mostly the work will be done in due course of time. Even then if the programme is crashing then there is issue in the software.   Thank you.   - Dr. Abhijeet Safai  ... View more

As far as I understand, your requirement is something like this -    A person is eligible for something, say some offer, only if that person has any of the visits within 30 day gap of another date. Is that correct? If I have understood the requirement correctly, then I would like to share the logic with which you can go ahead. At this point, I will not go into the programming but only the logic of it.    1) Find out eligible records. I guess a person has multiple records and only few records will be eligible. So first find out all the eligible records.    2) Once that is done, now we have to find out eligible persons and not records. If any of the record is eligible for a person, then the person becomes eligible. The person is not eligible only if any of the record of that person is not eligible. Hence find out eligible persons now.    3) Once you have eligible persons, keep only those (eligible) persons in the dataset and remove non eligible persons from the dataset.   Once you agree with the logic of the problem solving, please try to write programme for the same. If you do not agree with my articulation of the problem or if you think that I have not understood it correctly, please let me know it. Once you will start writing the programme with these 3 steps, feel free to let me know if you get stuck up somewhere.    Happy programming!   Thank you.   - Dr. Abhijeet Safai ... View more