I have a dataset like below. I would like to take the highest PCT (e.g. 0.82) and use its corresponding var2 (31) and var3(35), to append to the bottom of this dataset until the PCT reach 2, but use the same var2 (31) and var3(35)value., I am new to SAS array. Anyone could help? Thank you so much data test; input pct var2 var3; datalines; 0.8 1 11 0.81 2 22 0.82 31 35 ; run; proc print data=test; run; FINAL output should looks like 0.8 1 11 0.81 2 22 0.82 31 35 0.83 31 35 0.84 31 35 0.85 31 35 0.86 31 35 0.87 31 35 0.88 31 35 0.88 31 35 0.90 31 35 0.91 31 35 0.92 31 35 0.93 31 35 0.94 31 35 0.95 31 35 until 2 31 35
... View more