Help using Base SAS procedures

PRXMATCH to match series of variables

Reply
Regular Learner
Posts: 1

PRXMATCH to match series of variables

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_tam_t1_pam_t2_pam_t3_p
11111
12222
Super User
Posts: 17,963

Re: PRXMATCH to match series of variables

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

Super User
Posts: 10,552

Re: PRXMATCH to match series of variables

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.

Ask a Question
Discussion stats
  • 2 replies
  • 97 views
  • 0 likes
  • 3 in conversation