topic Re: How to get only positive values in SAS Programming

How to get only positive values

BrahmanandaRao — Thu, 05 Oct 2023 06:10:39 GMT

data test;
infile cards;
input A1 A2 A3 A4 A5;
cards;
-2 2 5 1 0
1 -2 5 1 2
;
run;
how to get only positive values ?

Re: How to get only positive values

PeterClemmensen — Thu, 05 Oct 2023 06:21:46 GMT

What is your desired result?

Re: How to get only positive values

BrahmanandaRao — Thu, 05 Oct 2023 06:28:02 GMT

Hi Peter,

I want get only positive values only A1 to A5 variables

Re: How to get only positive values

ballardw — Thu, 05 Oct 2023 06:35:08 GMT

What does the actual resulting data set look like?

One interpretation of your request would remove entire observations from the data set if any of the variables are negative.

Another would be to set the negative values to missing.

Another could be create custom format so that negative values appear as blanks in printed output.

Another could be remove a variable from a data set if any of its values are negative.

If I were more awake I might even come up with more meanings for "only positive values"

Re: How to get only positive values

Kurt_Bremser — Thu, 05 Oct 2023 07:39:14 GMT

Maxim 42.

Re: How to get only positive values

Astounding — Thu, 05 Oct 2023 07:48:10 GMT

Getting only positive values is easy. For example, you could program:

data want;
set test;
A1 = 7;
A2 = 7;
A3 = 7;
A4 = 7;
A5 = 7;
run;

However, if this is not the set of positive values that you have in mind, maybe you can describe what the result should look like.

Re: How to get only positive values

mkeintz — Thu, 05 Oct 2023 08:39:11 GMT

What do you mean by get in "get only positive values"?

I don't get it.