How to enable Parallel Processing in SAS EG

Guys if you’re looking how to enable Parallel Processing in SAS EG in Grid environment then you’re at the right place.In this tutorial we will guide you how you can allow parallel execution on the same server in SAS EG. How to enable Parallel Processing …

Execute SAS Program Via Command Line in UNIX/LINUX Console

In this tutorial we will learn how to Execute SAS Program Via Command Line in UNIX/LINUX Console.Let’s take an example what parameter needed to execute a SAS program from Console. Execute SAS Program Via Command Line <SAS PATH> -work <WORK PATH> <Code Path>/DEMO.sas Here you …

Execute Operating System Commands from Your SAS Session Using MACRO

In this tutorial we will learn how to Execute Operating System Commands from Your SAS Session Using MACRO.In this session we’re going to create a macro function which is going to be used to execute Unix/Linux commands through SAS EG session. Execute Operating System Commands …

How to Extract Date,Time and Datetime in SAS

In this tutorial we will discuss how to Extract Date,Time and Datetime in SAS using inbuilt functions.To get better understanding we will discover data and time seperately then we concatenate these to populate datatime. How to extract Date in SAS In this example we will …

How to Migrate SAS Libraries from one library to another library

In this tutorial we will guide you how to Migrate SAS Libraries from one library to another library using proc migrate procedure.While migrating libraries you can set the encoding as per your requirement. Examples: Migrate SAS Libraries To migrate SAS libraries we need to follow …

How to Rebuild or Repair your Damaged SAS Datasets

In this tutorial we will guide you how to rebuild or repair you damaged SAS dataset using proc dataset procedure.Sometime due to some memory or physical storage issue the dataset get damaged and not accessible. How to Repair your Damaged SAS Datasets To repair your …

How to Copy and Move Datasets from Work to Other Library in SAS

In this tutorial we will learn how to copy and move Datasets from Work to Other Library in SAS. Hope you all know all the dataset which is created without library reference are by default stored in Work library and flushed when the session ends. …

LIBNAME Statement to Connect External Databases in SAS

In this tutorial we will see how we can use LIBNAME Statement to Connect External Databases in SAS what are the databases supported by SAS how to access table once we have created the libname to External Databases in SAS. Few popular External Databases in SAS …

How CONNECT TO STATEMENT Work in SAS

CONNECT TO STATEMENT in SAS is used when we want to connect database using explicit SQL pass-through let’s take an example using CONNECT TO STATEMENT to connect Teradata system.   PROC SQL ; CONNECT TO TERADATA(USER=<USERID> PASSWORD=”<PASSWORD>” SERVER=<SERVERNAME> DATABASE=<DATABASENAME> CONNECTION=GLOBAL MODE=TERADATA); CREATE TABLE DEMO AS …

SAS FIX – Application Error. SAS Enterprise Guide needs to close.

While opening SAS Enterprise Guide, you might see the following error: SAS FIX – Error Application Error. SAS Enterprise Guide needs to close. SAS Enterprise Guide has encountered a problem and needs to close. We are sorry for the inconvenience. ‘.’, hexadecimal value 0x00, is …