converting numeric data to characters
I had to import several data type columns into jmp as numeric (coded 1-4, for example). I'd like to convert the numbers to more meaningful characters. For example in a column labeled "SITE", I'd like to make the following change:
1==DL
2==SL
3==KA
4==MP
Should this be done in the formula editor with a series of IF statements, or is there a cleaner way. If I use IF statements, then how can I delete the original numerically coded columns. Thanks in advance.
