3 weeks ago
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.
3 weeks ago - last edited 3 weeks ago
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;
Need further help from the community? Please ask a new question.