Hello! I am attempting to create a variable in my data that is the sum of the characters in a string (comprised of 0s and 1s). The code below does sum the 1s in the string, but I'm not sure how to manipulate it to provide the information that I'm looking for. For those whose strings start with 1s and change to 0s, that is ok. For those whose strings start with 0, regardless of the 1s that may follow, those need to be set to 0. Lastly, for those whose strings have 0s in the middle of the 1s, I need to only sum the 1s before it hits the 0. I apologize if this seems confusing and have tried to provide an illustration below of the string and the sum that I would like to calculate. Any help would be most appreciated! x_all sum that code below calculates sum that I want 1111111000000 6 6 0000001111111 7 0 1111000111111 10 4 data want (drop = i ); set have; x_total=0; do i=1 to length(x_all); x_total+input(substr(x_all,i,1),1.); end;
... View more