I have two separate data files (one for eye movements and one for performance on a task). I want to combine these two data files into one file so that I can analyze them with one another, but am running into troubles on how to get started.
The two data files have nothing but the participant file name in common and have varying amounts of responses per participants (ie. The eye movement data has more responses per participants compared to the task performance file).
I have uploaded the files to this post.
Guidance would be very helpful!!
See Help > Books > Using JMP and the topic is the Join command in the Tables menu. You want to be sure not to drop multiple matches. JMP will expand the rows to make sure that all the data for each ID is captured in the join.
Sorry about that. I looked at your variables and I am not sure how one would combine them. I only see a file name in one of the tables. I will leave it to a database guru in the community to come to your rescue!
Are you sure you want to join the tables rather than concatenating them? I'm not clear on what joining them will accomplish - you have multiple rows in each data set - in what way is it meaningful to line them up side by side? If you can explain that, I can probably tell you how to join them. But you might want to concatenate them instead - all the data will be in one file, but only the common column names will be "joined" (vertically).
I can see a method for joining the data tables, but that you would have to summarize the data down to the Participant. This might be what you want, if the summarization results in meaningful data.
If the problem you now have is that the outcome variables are in different columns, each of which has much missing data, then you might try this: create new columns that use existing columns when data is missing, otherwise the data that is not missing. In other words, you have an IF statement that says IF(ISmissing(data) then Other Data, else Nonmissing Data. You may need a multilevel IF statement to bring in all the outcome variables into a single column for analysis.
There are no labels assigned to this post.