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

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

luigipugliese — Thu, 22 Feb 2018 22:35:03 GMT

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.

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

Reeza — Thu, 22 Feb 2018 22:45:45 GMT

@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.

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

luigipugliese — Thu, 22 Feb 2018 22:56:57 GMT

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

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

luigipugliese — Thu, 22 Feb 2018 22:59:20 GMT

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

thanks in advance.

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

Reeza — Thu, 22 Feb 2018 23:37:52 GMT

typo error -> you have the variable name wrong.