topic PRXMATCH to match series of variables in SAS Procedures

PRXMATCH to match series of variables

amber_t — Wed, 21 Jun 2017 22:02:01 GMT

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

Re: PRXMATCH to match series of variables

Reeza — Wed, 21 Jun 2017 22:18:59 GMT

Look at the SASHELP.VCOLUMNS data set. It has information on all your variables, formats and types of the data sets.

Re: PRXMATCH to match series of variables

ballardw — Wed, 21 Jun 2017 23:08:00 GMT

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.