Wow, I think this is the easiest way~~ Thank you~ ... View more

Hi Vasile01, I read this note and It did helped me to understand the storage and user-defined format. Perhaps I could try to build some format catalogs to store my defined format somewhere separately from my coding. Thanks a lot for the useful information!! ... View more

Hi, Sandhya, I tried your code and I think it is a more efficient way of dealing with format as well as avoiding potential format error. Thank you so much!! ... View more

Thank you a lot!! Sandhya, yeah, the problem is I used proc format to define some formats when I revised the data set. As you suggest, now it opens once i run the proc format again!! Another question follows: it seems like the proc format could bring potential problem if I want to share the data with my colleagues especially when they don't know how I defined the user-defined format. But I like proc format personally because it does help a lot for analysis or creating report. So any suggestions about when this proc format should be used? Again, thanks for solving my problem 🙂 ... View more