cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar

How to link header with survey questions

I have a table t1 with survey questions. The columns are called 1a, 1b, 2a, 2b, etc. (rows are the respondents' answers). I have another table t2 with the actual questions matching the column names of t1. How can I link the column names of t1 with the actual questions in t2? For instance, assume I do a PCA, I would like to be able to read/reference the actual questions instead of 1a, 2b, etc when looking at loadings. I am currently on version 16.

1 REPLY 1
jthi
Super User

Re: How to link header with survey questions

Cols menu has recode column names

jthi_1-1668626510240.png

 

And from Advanced you can find mapping

jthi_0-1668626497684.png

This should let you recode the columns 1a, 1b... to the questions. Other option could be to stack the data and then join the questions / use virtual join

-Jarmo

Recommended Articles