topic if then else in SAS Programming

if then else

robertrao — Thu, 24 Jan 2019 16:14:53 GMT

Hello,

I am trying to write a logic and have been getting an error. "statement is not valid or it is used out of proper order"

Could you help me figure out the mistake in these statements

data want;

set have;

IF (PalS_N/19 > .50) THEN
PalS = SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14)*19/(PalS_N);
ELSE IF (PalS_N/19 < .50) THEN PalS =SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14);

run;
run;

Re: if then else

Reeza — Thu, 24 Jan 2019 16:22:43 GMT

Show your log. And what happens if it equals 0.5?

@robertrao wrote:

Hello,

I am trying to write a logic and have been getting an error. "statement is not valid or it is used out of proper order"

Could you help me figure out the mistake in these statements

data want;

set have;

IF (PalS_N/19 > .50) THEN
PalS = SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14)*19/(PalS_N);
ELSE IF (PalS_N/19 < .50) THEN PalS =SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14);

run;
run;

Re: if then else

robertrao — Thu, 24 Jan 2019 16:29:01 GMT

Thanks Reeza for the reply.

If it equals 0.5 then it is to be included in the less than or equal to category (PalS_N/19 <= .50).

The following is the error

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: if then else

Reeza — Thu, 24 Jan 2019 16:40:03 GMT

Please post the full log. Where the error occurs tells you where the error is.

Re: if then else

robertrao — Thu, 24 Jan 2019 16:47:06 GMT

Thanks Reeza,

It finally worked. I had some RUN statements in between the statements and forgot to remove them !!!!

This statement worked!!!

IF (PalS_N/19 > .50) THEN
PalS = SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14)*19/(PalS_N);
ELSE PalS =SUM(PAL1,PAL2,PAL3,PAL4, B1, PAL5, C2, O2, PAL6, PAL7, Br7, PAL8, PAL9,PAL10, Sp21, PAL12, L1, PAL13, PAL14);

Re: if then else

mkeintz — Thu, 24 Jan 2019 18:23:52 GMT

@robertrao

I hope you regard your discovery of the problem diagnosis and fix as a demonstration of the wisdom of @Reeza 's request for the full log.

I do.