Hi, I need help to find macro variable has value or null. Below is my code. Data a; Input name $ amount; Datalines; Canada1 12.30 Canada2 45.90 Canada . France1 35.50 France2 55.50 France . ; Run; Data _null_; Set a; If name='Canada1' then do; Call Symput('x1',name); Call Symput('y1',amount); End; If name='Canada2' then do; Call Symput('x2',name); Call Symput('y2',amount); End; If name='France1' then do; Call Symput('m1',name); Call Symput('n1',amount); End; Run; If name='France2' then do; Call Symput('m2',name); Call Symput('n2',amount); End; Data b; Set a; If name= 'Canada' then do; Total_amunt=%sysevalf(&y1,&y2); End; Else if name='France' then do; Total_amunt=%sysevalf(&'n1',&'n2'); End=; In the above data step, &n1,&n2,&y1,&y2 values Would contains either values or null values. How can I manage if above macro variables have null values. I needs to sum all these numeric macro variables sum with in IF condition. Please help me.
... View more
