SQRT: Calculating the Square Root

How to: |

The SQRT function calculates the square root of a number.

Syntax: How to Calculate the Square Root

`SQRT(in_value)`

where:

- in_value
Numeric

Is the value for which the square root is calculated, the name of a field that contains the value, or an expression that returns the value. If you supply an expression, use parentheses as needed to ensure the correct order of evaluation. If you supply a negative number, the result is zero.

Example: Calculating the Square Root

SQRT calculates the square root of LISTPR:

```
TABLE FILE MOVIES
PRINT LISTPR AND COMPUTE
SQRT_LISTPR/D12.2 = SQRT(LISTPR);
BY TITLE
WHERE CATEGORY EQ 'MUSICALS';
END
```

The output is:

TITLE LISTPR SQRT_LISTPR ----- ------ ----------- ALL THAT JAZZ 19.98 4.47 CABARET 19.98 4.47 CHORUS LINE, A 14.98 3.87 FIDDLER ON THE ROOF 29.95 5.47

Information Builders |