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
How to create an iterative procedure to check variable by variable whether a given observation satisfies some criteria - string variables- Extracting first five and last three parts from string variable.
- if time dummies are dropped in system GMM; How we can interpret? - xtabond2
- Which family and link for GLM?
- Clustering standard errors at industry level
Subscribe to:
Post Comments (Atom)
0 Response to Splitting An Instance into two existing attributes
Post a Comment