topic Re: How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end; in Discussions

How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

poulravn — Mon, 22 Jul 2013 08:24:28 GMT

Hi, I want to be able, in a scripted formula, to assign a text string to column depending onthe values of another column.

For instance:

A B

1 Low

2 Low

3 Low

4 Medium

5 Medium

6 Medium

7 High

8 High

9 High

10 High

How does the formula lok for this? If(:A<=3,"Low",:A>=3 and :A<7,"Medium",:A>=7,"High") does not work.

I Base SAS there is a command, select(); when();when(); ; ; otherwise;end; It is the equivalent of this I am looking for.

Regards

Poul Ravn Sørensen

Re: How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

scott_mitchell — Mon, 22 Jul 2013 08:53:02 GMT

You could use a format:

DATA HAVE;

DO A = 1 TO 10;

OUTPUT;

END;

RUN;

PROC FORMAT ;

VALUE RATING

LOW - 3 = "LOW"

4-6 = "MEDIUM"

7 - HIGH = "HIGH";

RUN;

DATA WANT;

SET HAVE;

B = PUT(A,RATING.);

RUN;

Or Using:

DATA WANT;

ATTRIB C LENGTH = $6;

SET HAVE;

/* B = PUT(A,RATING.);*/

IF A <= 3 THEN C = "LOW";

ELSE IF 4 <= A <= 6 THEN C = "MEDIUM";

ELSE C = "HIGH";

RUN;

Re: How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

djchavda — Mon, 22 Jul 2013 08:56:45 GMT

Hi,

Try this

if A <= 3 then B="Low";

else if A > 3 and A <= 6 then B="Medium";

else B="High";

Re: How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

poulravn — Mon, 22 Jul 2013 08:59:03 GMT

I am sorry. This is the SAS program version, but I was trying to find the JMP Script formula for the same. Should have been more precise. Exactly this example shows how you would sometimes prefer to have a more comprehensive Scripting Guide. I found nothing to help me in the guide.

Regards

Poul

Re: How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

poulravn — Mon, 22 Jul 2013 09:01:03 GMT

Again I am sorry; this works fine in SAS but I am looking for the JMP Formula (based on IF, MATCH or CHOOSE?) that does the same.

Regards

Poul

Re: How to extend the IF command in a formula? Equivalent of select;when;when;otherwise;end;

Jeff_Perkinson — Mon, 22 Jul 2013 13:49:15 GMT

Hi Poul,

You've got the right idea, just the wrong logical operator.

In JSL the AND operator is &. So, your formula should be:

If(:A <= 3, "Low",

:A >= 3 & :A < 7, "Medium",

:A >= 7, "High")

-Jeff