SAS Financial Functions

SAS - Floor

What is it?

Returns an integer

Floor 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 = floor(2.2);
    Result_2 = floor(-2.3);
    Result_3 = floor(1+1.e-10);
    Result_4 = floor(-1+1.e-10);
    Result_5 = floor(1+1.e-12);
    Result_6 = floor(311.389);
    Result_7 = floor(869);
    Result_8 = floor(-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 Floor function using a variety of numeric formats

CEIL Examples:

Floor	Input	Output
Result_1	2.2	2
Result_2	-2.3	-3
Result_3	1+1.e-10	1
Result_4	-1+1.e-10	-1
Result_5	1+1.e-12	1
Result_6	311.389	311
Result_7	869	869
Result_8	-314.178	-315

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.