Emeritus just means they’re retired with honors. Often they still teach an occasional class and, yes, do research and have an office and are affiliated (Professor Emeritus, University of the Swamp).

Is there a reason you ask? If you want to study with an emeritus, that is unlikely, depending on how much they want to be involved with students.