topic Question on how to create a column based on the values of another column in SAS Programming

Question on how to create a column based on the values of another column

MarvelJJ — Fri, 02 Aug 2019 07:09:11 GMT

I am using SAS University Edition. So I need to create a new column based on column x3. The new column is yes/no where 1 is yes and 0 is no. If the value of column x3 is 50 or greater, the new column would indicate 1. If it is less than 50, the new column would indicate no. I have tried various ifelse statements and I cannot seem to get it to work. I am novice to SAS, any help would be appreciated.

Re: Question on how to create a column based on the values of another column

Shmuel — Fri, 02 Aug 2019 07:41:34 GMT

You should post your code, the log and explain what issues you have.

Re: Question on how to create a column based on the values of another column

MarvelJJ — Fri, 02 Aug 2019 08:23:10 GMT

I am not sure how to get SAS to create the column with the data. I just keep getting errors.

data work.data;
	set work.import;
run;


if x3 > 49 then X7 = 1;
else if x3 < 50 then x7 = 0;
run;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 data work.data;

74 set work.import;

75 run;

NOTE: There were 50 observations read from the data set WORK.CRIME.

NOTE: The data set WORK.CRIME has 50 observations and 7 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

78 if x3 > 49 then X7 = 1;

180

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

79 else if x3 < 50 then x7 = 0;

____

180

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

80 run;

82 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Question on how to create a column based on the values of another column

Kurt_Bremser — Fri, 02 Aug 2019 08:26:34 GMT

data work.data;
	set work.import;
run; /* this premature run statement terminates the step and causes the following statements to be invalid */
/* remove it */


if x3 > 49 then X7 = 1;
else if x3 < 50 then x7 = 0;
run;

Re: Question on how to create a column based on the values of another column

KachiM — Fri, 02 Aug 2019 08:29:02 GMT

data work.data;
	set work.import;
run;


if x3 > 49 then X7 = 1;
else if x3 < 50 then x7 = 0;
run;

Remove the inner "RUN" and test the program. It can also be written as:

data work.data;
	set work.import;
       x7 = 0;
     if x3 > 49 then X7 = 1;
run;