topic Errors when trying to add new column to existing data set in New SAS User

Errors when trying to add new column to existing data set

dkeine — Fri, 09 Nov 2018 21:42:13 GMT

I am trying to add a column named "ADM_YN" to an existing data set.

When I input:

data=DID.MLIP101;
set=DID.MLIP1;
IF Antidepressants__ gt 0 THEN ADM_YN= "y";
IF Antidepressants__= 0 THEN ADM_YN= "n";
run;

I get this error for every line:

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

What am I doing wrong?

Re: Errors when trying to add new column to existing data set

Shmuel — Fri, 09 Nov 2018 21:47:04 GMT

Code should be:

data   DID.MLIP101;
  set   DID.MLIP1;
         IF Antidepressants__   gt 0 THEN ADM_YN= "y";
         IF Antidepressants__    = 0 THEN ADM_YN= "n";
run;

Re: Errors when trying to add new column to existing data set

novinosrin — Fri, 09 Nov 2018 22:25:34 GMT

HI @dkeine Welcome to the SAS forum. In addition to the correction you received , since your conditions are mutually exclusive, you are better off adding a else if

data   DID.MLIP101;
  set   DID.MLIP1;
         IF Antidepressants__   gt 0 THEN ADM_YN= "y";
         else IF Antidepressants__    = 0 THEN ADM_YN= "n";/*else if*/
run;