I have a table 'PMIdata' with 3 columns; 1st column is the date (monthly), 2nd column is a numeric value 'PMInum' corresponding to that date (economic growth) and 3rd column is a moving average of the second column 'PMIave' (so again numeric). I would like to add a fourth column 'AboveMA' to the table that specifies whether for each element in the 2nd column if it is greater than the corresponding element in the 3rd column, i.e. a binary variable of 0 or 1 indicating if the value is greater than its moving average (for all given dates).
I think this should be done using an 'IF' statement but I'm not sure of the syntax to navigate through the arrays and how to append this fourth column to the table.
Any help would be appreciated.