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
Need help with Mean for Grouped DataArray Good morning Stata Family, Please I want to create a new variable for the average wage earne…
marginal effectsDear everyone, I have a regression on GDP where I include both inflation, inflation^2 and one lag o…
Generating new ID variable taking into account duplicates across 2 other variablesFirst time poster, so I’m sorry for any errors… I have two ID variables (ID1 and ID2). I want to cr…
Specification of treatment and control group in diff-in-diffDear all, I am doing a difference-in-differences estimation to see the effect of a parental leave re…
Endogeneity test for two endogenous variables using REIV (xtivreg, re)Dear all, I am using an REIV using the command "xtivreg, re". I have two endogenous variables, y2 a…
Subscribe to:
Post Comments (Atom)
0 Response to Splitting An Instance into two existing attributes
Post a Comment