07-28-2014 04:38 PM
Looking for some assistance in putting together a new string variable. Due to bad data entry from various sources, I need to somehow make the data element consistent. Currently I have data sample #1- under column heading 'p_ds' there are dashes and spaces within the character string. I would like to create a new variable that would 1) eliminate the dash '-' in obs 1, 2 and 4. and 2) eliminate the space in position 3 and position 9 in obs 5.
|5||05 61564 6003420||8|
I would like my final dataset to look like sample #2. How can I best approach this?
Need further help from the community? Please ask a new question.