06-21-2017 06:02 PM
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!
06-21-2017 07:08 PM
If you asking if the PRX functions would work on the variable names then the answer is No.
It might help to provide a bid more input data, maybe 4 or 5 rows and then what the output for that is supposed to look like as "collapse the seris of variables" has many possible interpretations and a specific example would help.