SAS Libname Example

SAS Financial Functions

Libname Examples:

Postgres:

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

Proc SQL;
Select * from ABCDEFG.your_table;
Quit;

Parameter	Example	Description
Libname	ABCDEFG	The Libname which has to be 8 letters in length.
Server	Server_Address.com	The Host / Server location that your database is located.
Ports	5432	Port 5432 is the typical port number for PostGres Databases
User	Kevin	Database Username
Password	P@ssw0rd	Database Password

Oracle:

libname ABCDEFGH oracle path="(DESCRIPTION=
(ADDRESS=
   (PROTOCOL=TCP)
   (HOST=Server_Address.com)
   (PORT=1521)
)
(CONNECT_DATA=
   (SERVER=dedicated)
   (SERVICE_NAME=LMNOPQRS)
) )"
user=kevin password=P@ssW0rd;

Proc SQL;
   Select * from ABCDEFG.your_table;
Quit;

Parameter	Example	Description
LIBNAME	ABCDEFG	The Libname which has to be 8 letters in length.
PROTOCOL	TCP
HOST	Server Address
PORT	1521	Database Username
SERVER	P@ssw0rd	The Host / Server location that your database is located.
SERVICE_NAME	P@ssw0rd	Database Password
USER	Kevin	Database Username
PASSWORD	P@ssw0rd	Database Password

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.