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.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

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
  • 5935 views
  • 1 like
  • 1 in conversation