if then else syntax, trying to create a binary column, but only getting a column fill with 0s.

[luigipugliese]

Hi guys,

I am having a problem with a simple code. I am trying to use the if then else syntax but I feel like the else part is not been taken into account by SAS Studio. Here is the code: 

data WORK.HEART_plus;
set WORK.HEART_complete;
if AgeCDHdiag = . then cat_AgeCDHdiag=0;
else cat_AgeCDHdiag=1;
run;

The WORK.HEART_complete table comes from filtering the missing values of the smoking, weight, and cholesterol variables from the HEART table. 

[Reeza]

---

@luigipugliese wrote:

Hi guys,

I'm not a guy so I guess I shouldn't answer your question?

Check your log, there's likely a note about an variable not being initialized which points to a typo error. If not, post your full code and log. 

---

@luigipugliese wrote:

Hi guys,

I am having a problem with a simple code. I am trying to use the if then else syntax but I feel like the else part is not been taken into account by SAS Studio. Here is the code: 

data WORK.HEART_plus;
set WORK.HEART_complete;
if AgeCDHdiag = . then cat_AgeCDHdiag=0;
else cat_AgeCDHdiag=1;
run;

The WORK.HEART_complete table comes from filtering the missing values of the smoking, weight, and cholesterol variables from the HEART table. 

---

[luigipugliese]

sorry, just wanted to say hi in a general way. thanks for the reply.

[luigipugliese]

what does it mean when a variable is uninitialized? I think that is the only relevant note from the LOG.

thanks in advance.

[Reeza · Accepted solution]

typo error -> you have the variable name wrong.