topic Re: DATA Step adding variables in SAS Enterprise Guide

DATA Step adding variables

DME790 — Thu, 31 May 2018 05:23:06 GMT

Hi All,

I am using the IF statements to allocate numbers to variables, then I need to create a new variable that shows the total of these.

But when I use I create the new variable in another data step it doesn't add them together.

IF Active_INAa > ' ' THEN
		INAa = 1;

	IF Active_INDa  > ' '  THEN
		INDa = 2;

	IF Active_IRSa  > ' '  THEN
		IRSa = 4;

	IF Active_INIa  > ' '  THEN
		INIa = 8;

Data work.Test2;
	SET work.Test1;
	Total = INAa + INDa + IRSa + INIa;
RUN;

The Total column is created but is blank.

What am I missing here? Any help appreciated.

Cheers

Dean

Re: DATA Step adding variables

novinosrin — Thu, 31 May 2018 05:28:14 GMT

missing+value=missing

so try

total=sum(INAa ,INDa , IRSa, INIa);

Re: DATA Step adding variables

SASKiwi — Thu, 31 May 2018 05:30:22 GMT

Try a SUM statement if you want to add them up across your whole dataset:

Data work.Test2;
	SET work.Test1;
	Total + INAa + INDa + IRSa + INIa;
RUN;

Re: DATA Step adding variables

DME790 — Thu, 31 May 2018 05:31:51 GMT

Thanks @novinosrin

Works now.

Cheers

Dean