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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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