topic Re: How do I print values between two particular integers using Do while loop in SAS Programming

How do I print values between two particular integers using Do while loop

akhilesh_joshi — Wed, 26 Oct 2016 13:03:55 GMT

Hi,

I am new to SAS programming. I am finding way to solve the following problem.

The existing programming prints 2 to 15 levels output. If I would like to print only the levels between a particular value (say 😎 and 15, how do I achieve it using do or do-while loops.

Current sample output:

x_2 = x_1+(((1)/15)*y;
x_3 =x_1+(((2)/15)*y);
.
.

.
x_15 = x_1+(((14)/15)*y);

Re: How do I print values between two particular integers using Do while loop

Astounding — Wed, 26 Oct 2016 13:45:02 GMT

Here's one way:

proc format;

value blanks low-<5, 8 <- high = ' ';

run;

proc print data=have;

var x_2 - x_15;

format x_2 - x_15 blanks.;

run;

Re: How do I print values between two particular integers using Do while loop

akhilesh_joshi — Wed, 26 Oct 2016 13:52:40 GMT

Hi Astounding,

Thanks for your reply. So does that mean that if I specify level 8, it would print only X_9 to X_15? Also, can't it be done using loops? say a do or do-while loop. I am trying to understand the solution you gave.

Thanks,

Akhilesh

Re: How do I print values between two particular integers using Do while loop

Astounding — Wed, 26 Oct 2016 13:57:39 GMT

This solution prints all the variables, using PROC PRINT. For any value that is out of range, it prints a blank instead of the actual value.

If you don't want to see even those blanks, it takes more complex programming and results in uglier output. But it can easily be done if that is a better outcome.

Re: How do I print values between two particular integers using Do while loop

ballardw — Wed, 26 Oct 2016 14:17:21 GMT

Which is why we suggest providing example input and output.