I created an example of my data that I am using.  The difference is that there are over 1000 different variables that are repeated like the example below. My ultimate goal is to collapse the series of variables into one variable. Here it would be collapsed into am_t_p. I need to be able to count the number of variables in each series. There are so many different variables that I can count them individually. Would prxmatch and prxparse work with counting them or is there another way to capture those variables so that I can transpose them? Thank you!   id_t am_t1_p am_t2_p am_t3_p 11 1 1 1 12 2 2 2 ... View more