Print number in Decreasing order without proc sort

[abhaykumar]

I have to print all the numbers less than 500 which is divisible by 7 in decreasing order WITHOUT using PROC SORT.

[PeterClemmensen]

Why are you not allowed to use proc sort? 🙂

Are you allowed to use proc sort inside a call execute statement in the data step? 

[abhaykumar]

To find some other method to solve this problem .

[abhaykumar]

Proc sort is not been taught in class yet.

[Kurt_Bremser · Accepted solution]

data test;
do i = 500 to 1 by -1;
  if mod(i,7) = 0 then output;
end;
run;

proc print data=test noobs;
run;

[abhaykumar]

Thank You sir, I was trying this way but I was not knowing about "By -1" thing. and I guess we can increase or decrease by any value by using "by -/+n" step, right?

[Kurt_Bremser]

---

@abhaykumar wrote:
Thank You sir, I was trying this way but I was not knowing about "By -1" thing. and I guess we can increase or decrease by any value by using "by -/+n" step, right?

---

Correct. You can even use values with fractions.

Like

data test;
do i = 10 to 0 by -1.5;
  output;
end;
run;