Hi All,
I'm trying to write a data step with IF THEN ELSE statements.
I have 2 columns and I'm trying to create a third column based on these two columns.
table:
column 1 column2 new_column
A 1 X
A 4 X
A 5 X
B 2 Y
B 3 Y
B 8 Y
C 1 X,Y
C 2 X,Y
C 7 X,Y
IF a value in column 1 has value '1' in column 2 then the new column should be X and all the other rows should be X related to that column1 value A.
IF a value in column 1 has value '2' in column 2 then the new column should be Y and all the other rows should be Y related to that column1 value B.
IF a value in column 1 has value ('1','2') in column 2 then the new column should be (X,Y) and all the other rows should be X related to that column1 value C.
Could you help me with the syntax for this logic. The data set I'm working on had more than 300,000 rows. Thank you.
... View more