You are right, thanks. ... View more

data have; infile cards truncover; Input X1-X10 ; cards; 7.2 8.1 8.2 9.1 1.1 1.4 5.2 2.3 7.1 8.1 1.5 8.1 8.1 8.3 8.2 8.1 2.1 2.2 2.5 7.3 7.1 7.2 8.1 8.0 8.3 8.1 9.1 ; run; data want; set have; array x{*} x1-x10; array y{*} y1-y10; do i=1 to dim(x); if not missing(x{i}) then y{i}=mod(x{i},1); end; do m=1 to i-2; do n=m+1 to i-1; if y{m}<y{n} then do; temp=x{m};x{m}=x{n};x{n}=temp; temp=y{m};y{m}=y{n};y{n}=temp; end; end; end; drop temp y1-y10 i m n; run; ... View more

This works well when there are repeated values of a1 in Have1. Thank you KurtBremser. ... View more

Thank you very much Shmuel. That is exactly what I wanted. ... View more

Thank you all for your kind help in solving my problem.  Reeza's guide to array was educational. A bit long but PSNn's solution worked just fine. I also liked the simplified array by s_lassen. The easiest to follow was with reverse function by SuzanneDorinski. Again thank you all, I appreciate your time and help. Sijansap                      ... View more

Hi BallardW,   Thank you for your quick reply and suggestion. Your suggestion will help me for X1, and whenever X1 through X5 ( in this case) have same rule to missout. With this at least I have more than half way simplified since some variables have the same rule, and some have different. When there is different rule, I will use your technique and give different names to the variables that have different rule.   Thanks again, Sijansap   ... View more

Dear BallardW, Thank you so much for your help. This format statement is much faster and easier for me to convert the data I have. I appreciate very much for your kindness and help. Sijansap ... View more

Thanks again PGStats. I switched X1 and X2 in the inequality to preseve zeroes, and worked perfectly. I truly appreciate your help.   Sijansap   ... View more

True. New by here, did not know exactly the rules before. I received help already in another sas community.   Thanks  Regards   ... View more

Thank you for your time BallardW. I used the codes suggested by Darycut and it worked for me. ThanKs anyway. ... View more