SAS Financial Functions

SAS - CEILING

What is it?

Returns an integer

CEILING 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 = ceil(2.2);
    Result 2 = ceil(-2.3);
    Result 3 = ceil(1+1.e-10);
    Result 4 = ceil(-1+1.e-10);
    Result 5 = ceil(1+1.e-12);
    Result 6 = ceil(311.389);
    Result 7 = ceil(869);
    Result 8 = ceil(-314.178);
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
8 Tests of the CEIL function using a variety of numeric formats

CEIL Examples:

CEIL	Input	Output
Result 1	2.2	3
Result 2	-2.3	-2
Result 3	1+1.e-10	2
Result 4	-1+1.e-10	0
Result 5	1+1.e-12	1
Result 6	311.389	312
Result 7	869	869
Result 8	-314.178	-314

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.