I have a dataset that includes two variables called "NAME" and "TITLE".
NAME should simply be an individual's birth name (e.g. "John William Figueroa") and title should be anything appended to the end (e.g. OBE, MD, PhD, JD). Trouble is, a lot of entries instead have this information in the NAME column so that it reads "John William Figueroa, PhD".
Is there an easy way to use the comma (very frequently present) to shift the title into the next column? I'd use the "split" function but I don't want this broken into two new variables, just want to shift some of the information one line over. Thanks so much for your time!
Best,
Chuck
Related Posts with Splitting An Instance into two existing attributes
What stats are appropriate to assess model fit for nested logit models if Wald is not possible for clustered data?- Difference between catplot and tabplot
- Trying to code for a loop to clean data entry errors and destring my variables.
- Specifying model correctly with xtmixed
- How do I combine observations within a dataset?
Subscribe to:
Post Comments (Atom)
0 Response to Splitting An Instance into two existing attributes
Post a Comment