Create new varaible (column) based on data in same row from multiple varaiables.

I have a matrix of data [ trial, block, IV1, IV2, IV3, DV ]. I want to create a new variable based on the different levels of IVs 1-3 for multiple subjects.

n: 6

trials: 384

blocks: 8

IV1: 3 levels

IV2: 2 levels

IV3: 2 levels

new variables wold have 12 conditions.

[Rik]

How would your new variable look? What have you tried to create it?

[Nikhil]

As 3,4,5 columns are your IV values, you can create a new column using your data.

If your table name is temp. You can do it like

temp(1,7) = temp(1,3) + temp(1,4) * temp(1,5) (7 here indicates new column)

That will create a new column in the table and fill it using your desired value.