I need to count how many numbers starting with '1' '2' '3's in each observation. There are 700 variables and 50000 observations. I use the following code, data want; set have; array chars $ chars1-char700; array counts counts1-counts3; do over chars ; if substr(chars,1,1)=1 then counts1+1; if substr(chars,1,1)=2 then counts2+1; if substr(chars,1,1)=3 then counts3+1; end; run; but the counts on each observation is adding on top of the result (counts) from the last observation. How can I count them for each observation? (the counts need to star from 0 for each observation) Many thanks
... View more
