BookmarkSubscribeRSS Feed
🔒 This topic is locked. We are no longer accepting replies to this topic. Need further help? Please sign in and ask a new question.
SAS_Tipster
Moderator

The ABS function can be used to return a positive value...

 

DATA POSITIVE_INTEGER;
  VALUE = abs(-789);
RUN;

PROC PRINT;RUN;

 

The SUMABS function is also available, and computes the sum of the absolute value of the non-missing arguments.  This example returns a value of 14.

 

DATA POSITIVE_INTEGER;
 VALUE = sumabs(-1, 3, 0, ., -10);
RUN;

PROC PRINT;RUN;

You can also use the OF variable range syntax to include all variables that match a pattern.

 

data _null_;
   x1=1;
   x2=3;
   x3=4;
   x4=3;
   x5=1;
   x=sumabs(of x1-x5);
   put x=;
run;

Thanks to Ayetullah for sharing this tip on sasCommunity.org.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Visit a random SAS tip This SAS Tips board is not open for replies or comments, but we welcome your feedback and questions. Have a question or comment about this tip? Start a new topic in one of our discussion boards, and reference this tip topic.
Discussion stats
  • 0 replies
  • 6327 views
  • 1 like
  • 1 in conversation