Hello Vijay Ji (@Vj_Govindarajan )! Greetings!   I am a medical doctor and a researcher and an analyst of clinical trials data. This post was very helpful for me to understand the requirement of window functions in SQL.    The moment "non-SAS-users" understand that we have BY-group processing in SAS, they will immediately understand this is the way we do "windows". was rightly summarized by @yabwon !   Many thanks!   -- Dr. Abhijeet Safai   ... View more

Update: The issue seems to be solved for me. So I am happy. Finally it got solved on it's own. Sharing here because I think it is importnat to give updates. Thanks.    - Dr. Abhijeet Safai ... View more

Many many thanks @Kurt_Bremser . Currently I am dealing with a data which is extracted from PDF and if rounding used, it is giving different result for the same record if rounding is not used. It is interesting.    Thanks once again!   -- Dr. Abhijeet Safai ... View more

@Patrick , thanks!   Use of ?? before format is really useful. At least is was useful to me when there was some data issue. Seems that there were some characters which looked same (Week 12) to eyes but which were different in reality. Anyhow, use of ?? worked for me.    Thank you.    -- Dr. Abhijeet Safai ... View more

@Demographer , many thanks! 😊   -- Dr. Abhijeet Safai ... View more

@SASKiwi Ok. Thanks.   - Dr. Abhijeet Safai ... View more

Just wanted to document here that it is a very serious and big problem and lot of time is getting wasted as screen freezes. It is very frustrating as well.  I am sure that concerned people must be taking a note of it and must be involved in finding the solution but felt that I should share my experience. Thanks.    -- Dr. Abhijeet Safai  ... View more

In the meanwhile, I was able to find out one more workaround. If one opens the programme in SAS Universal Viewer and pasting from that place, then the screen is not freezing. So one solution is to open the programme in SAS Universal Viewer 'as well' when it is open in SAS 9.4.   Thanks.   - Dr. Abhijeet Safai  ... View more

generally the longer I am using SAS, the worse the problem becomes.    Yes. One workaround I was able to find was to close the SAS completely and then to start it again. The issue has gone away at least for now. Thanks for this workaround. Till the real solution comes, this workaround is also very valuable because it is saving lot of time and frustration. Thank you.   - Dr. Abhijeet Safai ... View more

I am facing the same issue and it is quite frustrating as lot of time is wasted. I am bookmarking this topic so that will get to know if any solution becomes available.    Thanks.   - Dr. Abhijeet Safai ... View more

Dear All.   I am replying to the main question again, to bring it to notice of experts here. I had thought that I will be able to find out the solution, but I am not able to find out even now. It is taking lot of time because opening a programme by double clicking is not possible. I request experts to kindly help if possible. It will save lot of time.    Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Many thanks @FreelanceReinh !   - Dr. Abhijeet Safai ... View more

Yes, I agree. However, it seems that it is not in my hands. I request admins to kindly mark this answer by @Astounding  as the accepted solution by removing the current answer by @Amir as a solution. Also, kindly feel free to delete this message.    Thanks in advance.   - Dr. Abhijeet Safai ... View more

@Astounding This is working! So many thanks. There is a minor change which will need to be made though. It is showing 'full path' but I need only the name of the programme. I will make changes for that but your answer is very very helpful. Many thanks!   - Dr. Abhijeet Safai ... View more

@FreelanceReinh Many many thanks! This is working perfectly. Thanks.    - Dr. Abhijeet Safai ... View more