@weweaw wrote: Hello, I want to make indicator variables if the second two digits are a particular set. The variable its self it char. The numbers go from 0-9 for both positions. If it was h678 then I want to make an indicator var to be called _67 (or nit67) and that to be 1. I've been trying to make a do loop but cannot make it work.  This is what I have: id nit 234 a019 453 b033 457 c101 And this is what I want: id nit _01 _02 _03 _04 _05 _06 _07 _08 _09 _10 234 a019 1 0 0 0 0 0 0 0 0 0 453 b033 0 0 1 0 0 0 0 0 0 0 457 c101 0 0 0 0 0 0 0 0 0 1   Thank you! I think you want something similar to: data want; set have; array _ _00-_99; test=input(substr(nit,2,2),best.); do i=1 to dim(_); _[i]= (test+1=i); end; drop i; run; Your "description" may have missed that you need to have an _00 indicator. If you intended 00 to be _100 you need to state so.   Test is the numeric value of the second and third characters. If that is not a valid number you will get 0 for all indicators. ... View more

Ok...given that it works for the sample data it's a bit hard to say what's wrong with yours.    1. Check correct variable mappings in all places 2. Check array definition - type out all H_ to test if necessary   data have; input ID $ H_Start H_End H_1 H_2 H_3 H_4 H_5 H_6 H_7 H_8 H_9 H_10 H_11 H_12; datalines; A 3 6 0 1 1 1 1 1 0 1 0 1 1 1 B 2 5 0 1 0 0 0 0 1 1 1 1 1 1 C 9 12 1 1 0 0 0 0 0 0 0 0 0 1 ; data want; set have; array _h(*) h_1 - h_12; do i=h_start to h_end; total_sum = sum(total_sum, _h(i)); end; run; ... View more

I am considering using proc rank . data class; set sashelp.class; ran=ranuni(0); keep ran; run; proc rank data=class out=temp groups=10; var ran; ranks rank; run; data want; merge temp(where=(rank in (0:4)) rename=(ran=A))        temp(where=(rank in (5:7)) rename=(ran=B))         temp(where=(rank in (8 9)) rename=(ran=C)) ; drop rank; run; Xia Keshan ... View more