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 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 …