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

This did not help me directly, because that was not my question, but this answer helped me indirectly to solve another problem. Thanks.   - Dr. Abhijeet Safai ... View more

Simply Amazing! Thanks!   - Dr. Abhijeet Safai ... View more

Hi Peter,   Greetings!   I also had the similar question as how to create a format from a dataset. I found following two sources useful.    1) SAS Documentation: https://documentation.sas.com/doc/en/vdmmlcdc/8.1/proc/n1e19y6lrektafn1kj6nbvhus59w.htm    2) A paper with title "Creating a Format from Raw Data or a SAS® Dataset " by Wendi L. Wright : https://support.sas.com/resources/papers/proceedings/proceedings/forum2007/068-2007.pdf   The paper is of 2007 and in documentation, a table named 'The CTLR Dataset' gives lot of information. However, if there is any better way of understanding it, please let me know.    Thanking you, Yours sincerely,   - Dr. Abhijeet Safai ... View more

Thanks a lot!  It was very helpful! 👍   - Dr. Abhijeet Safai ... View more

I found the reply helpful, but it is difficult to read the answer in current alignment. Hence, I am wring the same answer with proper alignment. ================================================================================= data _NULL_;           format dt datetime20. dt2 E8601DT20. ;           dt=datetime();           dt2=dt;           put dt= dt2=;           txt=put(dt,datetime20.);           txt2=put(dt2,E8601DT20.);           put txt= txt2=; run;   http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm   ================================================================================ Thanking you, Yours sincerely,   - Dr. Abhijeet Safai   ... View more

I was able to solve it with the help of following paper. Especially their idea of creating numeric sorting variables for soc and pt worked.    PharmaSUG China 2015 – Paper 02 Fifty Shades of Sorting Haibin Shu, AccuClin Global Services LLC, Wayne, PA John He, AccuClin Global Services LLC, Wayne, PA Elena Rojco, DentaQuest, Salem, NH   Link: https://www.lexjansen.com/pharmasug-cn/2015/PT/PharmaSUG-China-2015-PT02.pdf   Thank you.   Dr. Abhijeet Safai ... View more

At least at the moment, I have same query. I will share here if the query gets solved or if I get answer. Thanks. - Dr. Abhijeet Safai ... View more