SAS Tips from the Community

SAS tips from real SAS users like you
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-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

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