Thanks for the inputs. I'll put my efforts. ... View more

proc sort data=have out=want; by name res; run; data want; set want; by name res; if first.res then number=number; else number=0; run; ... View more

0.00256 0.00288 0.00256 0.00381 0.00256 0.00475 0.00267 0.00568 0.00270 0.00662 0.00288 0.00756 0.00288 0.00849 0.00314 0.00943 0.00320 0.01037 0.00320 0.01130 0.00321 0.01224 0.00323 0.01317 0.00326 0.01411 0.00332 0.01505 0.00345 0.01598 0.00351 0.01692 0.00351 0.01785 0.00353 0.01879 0.00353 0.01973 0.00354 0.02066 0.00354 0.02160 0.00363 0.02254 0.00371 0.02347 0.00378 0.02441 0.00380 0.02534 0.00383 0.02628   Thanks everyone I have applied above code from the following data but count not getting.. can some one check   Required output:   count    6 ---less then or equal to 0.00288 18----less then or equal to 0.00381   and so on..... ... View more

In the below which you written code the count gives as     b  count   1     4 2     5 3     6 4     8 5      8 6       8     b  count   1     4 2     1 3     1 4     2 5      0 6      0   In this way needed ... if a value is counted when it less then or equal to.. it should not repeat count again....       ... View more

0.2556% 0.2875% 0.2559% 0.3812% 0.2564% 0.4748% 0.2667% 0.5684% 0.2701% 0.6620% 0.2875% 0.7556% 0.2880% 0.8493% 0.3138% 0.9429% 0.3196% 1.0365% 0.3198% 1.1301% 0.3213% 1.2237% 0.3226% 1.3174% 0.3262% 1.4110% 0.3318% 1.5046% 0.3447% 1.5982% 0.3508% 1.6919% 0.3513% 1.7855% 0.3526% 1.8791% 0.3527% 1.9727% 0.3536% 2.0663% 0.3545% 2.1600% 0.3632% 2.2536% 0.3706% 2.3472%     some more clear on want I want thanks alot everyone ..but I need like B column value need to search for same and less then to A column value.. if it taken a count from A column it doesn't repeat count when it taken a new value in column B....example   I'm showing how it on small data to make clear...   a       b 1.1    1 1.2     2 1.3     3 2 2.1 2.2 3   Require output:   b c   1 0 2 4 3 1 ... View more