I still dont understand what it means by   condition1= >=3   let me check why but I am not sure if it was explain anywhere... ... View more

Data Portoa; input apple melon orange; datalines; 0 2 3 5 3 4 3 4 5 0 5 5 3 1 0 6 1 0 7 0 0 9 2 7 run; data test; set Portoa; con=0; bal=0; array curr_bal_P[*] curr_bal_P1 -curr_bal_P12; array compbal_inc[*] compbal_inc1 - compbal_inc12; curr_bal_P[1]=1000; curr_bal_P[2]=900; curr_bal_P[3]=800; curr_bal_P[4]=700; curr_bal_P[5]=600; curr_bal_P[6]=500; curr_bal_P[7]=400; curr_bal_P[8]=300; curr_bal_P[9]=200; curr_bal_P[10]=100; curr_bal_P[11]=50; curr_bal_P[12]=30; do i=1 to 11; j=i+1; if curr_bal_P[j] not in (.) then do; if curr_bal_P[i] > curr_bal_P[j] then compbal_inc[i]=1; else compbal_inc[i]=0; end; flag_bal=i; if flag_bal<=5 then do; if bal=0 then do; if compbal_inc[i]=1 then con=con+1;else bal=1; end; end; end; run; I added values for the arrays and run again. it seems ok. I can see the i and j but I don't get why i equals 12, thought it is 11 as max.   ... View more

but when i >5, that line is not run, so bal should be 0   right now bal =1 for all i why?   ... View more

oh I can see now for some strange reason both were unticked   what about the value of bal being 1 always? ... View more

Data Portoa; input apple melon orange; datalines; 0 2 3 5 3 4 3 4 5 0 5 5 3 1 0 6 1 0 7 0 0 9 2 7 run; data test; set Portoa; con=0; bal=0; array curr_bal_P[*] curr_bal_P1 -curr_bal_P12; array compbal_inc[*] compbal_inc1 - compbal_inc12; do i=1 to 11; j=i+1; if curr_bal_P[j] not in (.) then do; if curr_bal_P[i] > curr_bal_P[j] then compbal_inc[i]=1; else compbal_inc[i]=0; end; flag_bal=i; if flag_bal<=5 then do; if bal=0 then do; if compbal_inc[i]=1 then con=con+1;else bal=1; end; end; end; run; sorry please see updated version with full details of input dataset.  why I cannot see j and flat_bal in dataset test. log has no errors.   what decide what shows on output dataset here, why show i and not j or flat_bal?   ... View more

but 240 mean the no of month from 1219 to when? I still dont get the logic after I tried a few more   1219    240 months 1021    262 months 1217    216 months 1221   264 months  ... View more

what do you mean by mmyy format, I tried with 1219 and got missing for month ... View more

yes the user only provide data of 0,20,30 let me ask them again why are you sure it is mmyy format ?   ... View more

Just posted sgsin ... View more

data result; input YEARS_OF_IMP $5.; month=(input(YEARS_OF_IMP,4.)-int(input(YEARS_OF_IMP,4.)/100)*100)*12 +int(input(YEARS_OF_IMP,4.)/100); X=input(YEARS_OF_IMP,4.); month1 = (X-(int(X/100))*100)*12+int(X/100); test2=int(X/100); test2a=int(X/100)*100; test3=X-int(X/100)*100; test3a=(X-int(X/100)*100)*12; datalines; 0 20 30 15.5 12.8 12.3 14.1 ; proc print data=result; ... View more