topic Print number in Decreasing order without proc sort in SAS Programming

Print number in Decreasing order without proc sort

abhaykumar — Tue, 15 Nov 2016 14:32:58 GMT

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

Re: Print number in Decreasing order without proc sort

PeterClemmensen — Tue, 15 Nov 2016 14:39:01 GMT

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?

Re: Print number in Decreasing order without proc sort

Kurt_Bremser — Tue, 15 Nov 2016 14:42:28 GMT

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

proc print data=test noobs;
run;

Re: Print number in Decreasing order without proc sort

abhaykumar — Tue, 15 Nov 2016 14:42:00 GMT

To find some other method to solve this problem .

Re: Print number in Decreasing order without proc sort

abhaykumar — Tue, 15 Nov 2016 14:42:39 GMT

Proc sort is not been taught in class yet.

Re: Print number in Decreasing order without proc sort

abhaykumar — Tue, 15 Nov 2016 14:46:30 GMT

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?

Re: Print number in Decreasing order without proc sort

Kurt_Bremser — Tue, 15 Nov 2016 14:50:53 GMT

@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.

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