DATA Step adding variables

[DME790]

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

[novinosrin · Accepted solution]

missing+value=missing

so try

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

[DME790]

Thanks @novinosrin

Works now.

Cheers

Dean

[SASKiwi]

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;