Blog

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 …

How To Setup Auto Reply To Instagram Messages

HOW TO AUTO-REPLY TO INSTAGRAM MESSAGES : Anyone who manages a business account on Instagram knows that you need to set aside time in the day to Reply To Instagram Messages. The greater the interaction, the greater the number of doubts – and often the same question …