topic Re: How to work properly with the if else statements in SAS EG? in SAS Enterprise Guide

How to work properly with the if else statements in SAS EG?

AK100 — Tue, 15 Sep 2020 14:43:47 GMT

With below code I tend to make a new column based on the values of an other column. When I click run and check the 'column_x' I see just the letter 'F' for criteria 'N' instead of the word `Fixed` and for the else I see just the letter 'N' instead of 'Not fixed'.

data want;
set have;
if index(criteria,'N') then colum_x= "Fixed";
else column_x= "Not fixed";
run;

It seems like its just taking the first letters inside the parenthesis. Why is that and how can I fix it?

Re: How to work properly with the if else statements in SAS EG?

Astounding — Tue, 15 Sep 2020 14:49:51 GMT

This happens because your new variable isn't really new. HAVE already contains COLUMN_X (or perhaps COLUM_X, whichever spelling you are using) and it has a defined length of $1. You can change that by adding a LENGTH statement before the SET statement:

data want;
length column_x $ 9;
set have;
if index(criteria,'N') then column_x= "Fixed";
else column_x= "Not fixed";
run;

Re: How to work properly with the if else statements in SAS EG?

ballardw — Tue, 15 Sep 2020 15:55:18 GMT

If column_x were actually a new variable then the values you would see would be "Fixed" and "Not f".

If you do not explicitly set the length of a new variable then the first use will set the length. In this case that would be "Fixed" which is length 5. So "Not fixed" would be truncated to 5 characters.

Re: How to work properly with the if else statements in SAS EG?

Kurt_Bremser — Tue, 15 Sep 2020 16:31:28 GMT

Maxim 47.