All Posts...

If you're comfortable in working with SQL then a good news for you! SAS offers a procedure using which you can use your SQL queries in SAS.

Standardizing variables is needed when all the variables are of different scales. In this tutorial we'll learn about PROC STANDARD for it.

Datasets in SAS can be merged using : PROC SQL & Merge statement. In this tutorial we'll learn how to join or merge datasets using MERGE

PROC SORT is a very powerful procedure in SAS to sort the dataset at multiple levels and removing the duplicates.

Both IF and WHERE keywords are used to filter the datasets but not both of them can be used in all the situations.

SAS offers plethora of functions for string manipulations. In this tutorial we shall learn about them in detail.

SAS provides the provision i.e. PROC FORMAT to manually create a format which can be applied to multiple columns at one go.

Sometimes while reading and viewing a dataset we can have differences. All this is due to formats and informats.

PROC APPEND is used to append data vertically in SAS in an already existing dataset.

In SAS 'WHERE' keyword is used to retrieve those rows in a dataset which satisfy a particular condition.

Sometime in a code you don't want to create a dataset rather than want to see the output of something in log.

To increase the date by a month or a day or a year etc we have SAS' in-built INTNX function. In this tutorial we' cover it in depth.

In SAS, INTCK is used to compare two dates and returns the difference between them. We shall learn about it in depth.

In this tutorial we shall learn how to create or read datasets in SAS along with comma, decimal, colon informats and formats.

YEARCUTOFF is an important parameter in reading and defining dates in SAS which can affect the dates by a CENTURY.

SAS has got various dates formats and informats. In this tutorial we shall understand all of them in detail and how they are used.

In this tutorial we shall learn about FIRSTOBS and OBS in SAS with detailed examples.

In this tutorial we shall learn about how to export data from SAS using PROC EXPORT. We will focus on importing: CSV, EXCEL and TXT files.

In this tutorial we shall learn about how to export various datasets in a single excel (each data in a single sheet) in SAS.

In this tutorial we shall learn about how to import data in SAS using PROC IMPORT. We will mainly focus on importing: CSV and EXCEL files

In this tutorial we shall learn about how to do data manipulations and filter rows using IF ELSE in SAS.