SAS Financial Functions

SAS - Round

What is it?

Round is a function used to round numbers up or down
It accepts 1 or 2 values, the number, and how much to round it by

Syntax:

Round(number_to_round, optional_round_by_number);

Input Example:

libname ABCDEFGH postgres server="Server_Address.com" port=5432 user=kevin password="P@ssW0rd" database=DBName schema=SchemaName;

Data work.my_data_file;

    Result_1 = round(10.1);
    Result_2 = round(10.9);
    Result_3 = round(9, 10);
run;

proc
  print data=my_data_file;
run;

What's happening in the script above?

The script is connecting to the postgres database/datasource
Data step is creating the work.my_data_file temporary dataset
3 Examples of the rounding function on numbers

Informat Examples:

Variable	Input	Output	Description
Result_1	10.1	10	Rounded down to the nearest integer
Result_2	10.9	11	Rounded up to the nearest integer
Result_3	9	10	Rounded up to the nearest 10

Connect via LinkedIn

Kevin Regan

Have an article, idea, found a typo, want to contribute? Shoot me an email Here

Below are links to some Udemy Data Science Courses. I've been using Udemy for a number of years now, and I've found their courses super helpful, maybe you will also.