@Cynthia_sas This is fantastic! thank you for solving my question in short period of time. the #3 report was THE improvement from other approaches, with artful application of '_break_' automatic variable. I don't know much about it, but knowing it's the key to avoid the pitfall I experienced earlier. Also, appreciate the clear illustration why it's not working when used as 'order' variable comparing with usage of as 'display', as well as the useful tips of good practice regarding this special SAS procedure. Thank you!
... View more