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 |
Look at the SASHELP.VCOLUMNS data set. It has information on all your variables, formats and types of the data sets.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.