Hello, I am trying to use proc scq in order to add a new variable to existing data set, the new variable gives condition name for each observation. My next move will be to find average reaction times for each condition for each subject. The data set I have contains participant number (numeric), reaction times (numeric) and 4 variables (2string and 2 numeric) coding level of each corresponding factor. Each condition is produced by a combination of 4 variables. Below is a code which (I hope) is supposed to make a table, where I will have old table + a column "Cond". This column will have one of 16 condition names (string) in each line. proc sql;create table step2.w as
select visibility, soa, globality, prime, sub, rt,
case
when prime='NP' && globality='G' && soa=2 && visibility=0 then Cond='NpG0s2'
when prime='OP' && globality='G' && soa=2 && visibility=0 then Cond='OpG0s2'
when prime='NP' && globality='G' && soa=4 && visibility=0 then Cond='NpG0s4'
when prime='OP' && globality='G' && soa=4 && visibility=0 then Cond='OpG0s4'
when prime='NP' && globality='G' && soa=2 && visibility=1 then Cond='NpG1s2'
when prime='OP' && globality='G' && soa=2 && visibility=1 then Cond='OpG1s2'
when prime='NP' && globality='G' && soa=4 && visibility=1 then Cond='NpG1s4'
when prime='OP' && globality='G' && soa=4 && visibility=1 then Cond='OpG1s4'
when prime='NP' && globality='G' && soa=2 && visibility=2 then Cond='NpG2s2'
when prime='OP' && globality='G' && soa=2 && visibility=2 then Cond='OpG2s2'
when prime='NP' && globality='G' && soa=4 && visibility=2 then Cond='NpG2s4'
when prime='OP' && globality='G' && soa=4 && visibility=2 then Cond='OpG2s4'
when prime='NP' && globality='G' && soa=2 && visibility=3 then Cond='NpG3s2'
when prime='OP' && globality='G' && soa=2 && visibility=3 then Cond='OpG3s2'
when prime='NP' && globality='G' && soa=4 && visibility=3 then Cond='NpG3s4'
when prime='OP' && globality='G' && soa=4 && visibility=3 then Cond='OpG3s4'
else .
end as Cond
from step2.Clean;
quit; However, I receive an error message in the log: "ERROR: The following columns were not found in the contributing tables: Cond." I know that there is no such variable in the source table "step2.Clean". I want to create it and add it. Could you, please, tell me what am I doing wrong? I will greatly appreciate your feedback and time, Dina.
... View more