Somehow a similar problem just got solved for me. An ending bracket ")" was given extra in one of the calls to a macro and after removing that the problem got solved for me.    Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Correct!   I would like to go view nth record directly. Currently I have to keep scrolling till that record comes but can I go to a particular number of (nth) record directly? It will be a great feature if it could be implemented.    Thank you. - Dr. Abhijeet Safai ... View more

Many thanks. This use of scan function has saved lot of my time. It is very useful where substr is not useful because substr is position specific.   Thank you.   - Dr. Abhijeet Safai ... View more

Correct!   I was looking for the same and found it.   Thanks.   - Dr. Abhijeet Safai ... View more

Yes, he is absolutely wonderful! One of the datasets was not opening and it was because of dynamic format used. He advised to use options nofmterr and that has worked wonders and I can open the dataset. He has helped me on other occasions as well. Many thanks to him for being there. 😊   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

This is working!  options nofmterr;  is working absolutely fine @Kurt_Bremser !     Thanks once again! 😊   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

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

To rearticulate the problem:   The dataset contains a variable which has a format. This format is user defined. As this format (user defined) is not available to SAS (it is available only in that programme), the dataset is not opening.    But it is opening when the programme is run before, because then this user defined format becomes available to SAS.   Thank you.   - Dr. Abhijeet Safai ... View more

The problem is solved partially for me because I know why the problem is occurring.    I am running a programme in batch mode, which is creating multiple outputs. Now this programme is using a format which is a dynamic format getting created and being used from data. The dataset is not opening because the format is not getting loaded. The workaround for now for me is to run the programme and then open the dataset.    But yes, the issue is because a format is not getting loaded. It is a dynamic format.    So solution is not to use dynamic format (format getting created from data) and to use static values in the format.   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Same here! I will write here as the issue gets solved for me.   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

As per this documentation, it seems that it is not possible in SAS to 'Loop through a nonsequential list of values with a macro DO loop'   Thank you.   - Dr. Abhijeet Safai ... View more

Thanks a lot! It was very useful. Thanks once again!   Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Yes, it has at least helped me.    Thank you.   - Dr. Abhijeet Safai ... View more

Now I understood it. Yes, you rightly pointed out that by variable is not unique. It helped me to solve my issue. Thanks once again.    - Dr. Abhijeet Safai ... View more

Thank you. Still my problem is not solved on which I am working, but this answer has given me a good hint. Thanks once again.    - Dr. Abhijeet Safai ... View more