I have this hypothetical dataset:   MRN Height Weight 12345 65 22 12345 62 22 77111 60 33 77111 70 28 77111 58 35 Ultimately, I want to convert from long to wide, with variables like Height1, Height2, Weight1, Weight2, etc. using PROC TRANSPOSE. However, I need to create a "time" variable that indicates when the height and weight were measured before I can do this. I was thinking of counting the number of rows by MRN and adding a new column that goes from 1 to the number of rows by MRN. I need the dataset to look like this:   MRN Height Weight Time 12345 65 22 1 12345 62 22 2 77111 60 33 1 77111 70 28 2 77111 58 35 3   Any suggestions would be greatly appreciated. ... View more

Hi, I am using SAS to try to calculate the maximum value of a variable for each unique person. However, I want to retain the other columns of the dataset for the row that contains that maximum value. I've tried to use PROC SQL to accomplish this, but I have no idea how to make sure that the other columns also transfer over. For example, my dataset has 250,000 rows, but only 32,000 unique individuals. I want to find the maximum date for each unique person, and for the row that contains the maximum, I also want to retain all other columns. This is my code so far:   proc sql; create table test as select ID, max(date_var) from dataset group by 1; quit; Any help would be great. Thanks. ... View more