Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Q about absolute value

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Q about absolute value

A starter SAS user got a little confused on functions and procedures. Thanks for bearing me on this.

Suppose that I have a string of numbers of interval ratio from a survey, but here is the problem. I don't know how to sort it by absolute value. Should I create a variable to contain these absolute values in procedures step or I can have other solutions by using some functions?


Accepted Solutions
Solution
‎09-30-2011 08:34 AM
PROC Star
Posts: 7,363

Q about absolute value

Is the following what you are looking to do?

data have;

  input x;

  cards;

-5

-7

3

-1

4

;

proc sql noprint;

  create table want as

    select x

      from have

        order by abs(x)

  ;

quit;

View solution in original post


All Replies
PROC Star
Posts: 7,363

Q about absolute value

You've probably posted this in the wrong forum but you should post more info, anyhow, in order for others to know what you are seeking.  A small example of your data would help as well as an explanation of what you would ultimately like to accomplish with the data.

New Contributor
Posts: 3

Q about absolute value

For example, I have some numbers gained from the individual survey such as -5 -7 3 -1 4 -6 1 ... and I want to sort them by the power of absolute values then I could chose to display the survey question items by this order.

Solution
‎09-30-2011 08:34 AM
PROC Star
Posts: 7,363

Q about absolute value

Is the following what you are looking to do?

data have;

  input x;

  cards;

-5

-7

3

-1

4

;

proc sql noprint;

  create table want as

    select x

      from have

        order by abs(x)

  ;

quit;

New Contributor
Posts: 3

Q about absolute value

Yes. Smiley Happy Thank you so much for helping me out.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 637 views
  • 1 like
  • 2 in conversation