Okay, I want to do something similar to SAS proc format.
 
I usually do this...
 
a <- NULL
a$divisionOld <- c(1,2,3,4,5)
divisionTable <- matrix(c(1, "New England",
                          2, "Middle Atlantic",
                          3, "East North Central",
                          4, "West North Central",
                          5, "South Atlantic"),
                        ncol=2, byrow=T)
a$divisionNew[match(a$divisionOld, divisionTable[,1])] <- divisionTable[,2]
 
But how do I handle the case where...
a$divisionOld <- c(0,1,2,3,4,5)   #no format available for 0, this throws an error.
OR
divisionTable <- matrix(c(1, "New England",
                          2, "Middle Atlantic",
                          3, "East North Central",
                          4, "West North Central",
                          5, "South Atlantic",
                          6, "East South Central",
                          7, "West South Central",
                          8, "Mountain",
                          9, "Pacific"),
                        ncol=2, byrow=T)   
There are extra formats available... this throws a warning.
 
Thanks
 
Cory

	[[alternative HTML version deleted]]

