How do I create a counting variable based on another column & transpose a table?
Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...