Hi I just used a sum function in VIYA (3.5). To my suprise sum(1,.) returns missing. in 9.4 it would return 1. Is the sum function changed in VIYA?
Maybe it was a bug in a previous version.
77 78 data _null_; 79 x1 = sum(1,.); 80 put x1=; 81 run; x1=1 NOTE: DATA statement used (Total process time): real time 0.00 Sekunden cpu time 0.01 Sekunden 82 83 %put &=sysvlong; SYSVLONG=V.04.00M0P031422
Maybe it was a bug in a previous version.
77 78 data _null_; 79 x1 = sum(1,.); 80 put x1=; 81 run; x1=1 NOTE: DATA statement used (Total process time): real time 0.00 Sekunden cpu time 0.01 Sekunden 82 83 %put &=sysvlong; SYSVLONG=V.04.00M0P031422
Thanks, works as intended. I had another fault in my code and got stuck. Bad post by me
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.