Ekta Aggarwal
PROC SQL - Run SQL queries from R
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.
All Posts...
Search
Ekta Aggarwal
- Jan 23, 2021
PROC STANDARD - To standardize or normalize the variables.
Standardizing variables is needed when all the variables are of different scales. In this tutorial we'll learn about PROC STANDARD for it.
Ekta Aggarwal
- Jan 22, 2021
Merging data in SAS
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
Ekta Aggarwal
- Jan 22, 2021
PROC SORT in SAS
PROC SORT is a very powerful procedure in SAS to sort the dataset at multiple levels and removing the duplicates.
Ekta Aggarwal
- Jan 21, 2021
Difference between WHERE and IF in SAS
Both IF and WHERE keywords are used to filter the datasets but not both of them can be used in all the situations.
Ekta Aggarwal
- Jan 21, 2021
String functions in SAS
SAS offers plethora of functions for string manipulations. In this tutorial we shall learn about them in detail.
Ekta Aggarwal
- Jan 21, 2021
PROC FORMAT - With detailed examples!
SAS provides the provision i.e. PROC FORMAT to manually create a format which can be applied to multiple columns at one go.
Ekta Aggarwal
- Jan 21, 2021
FORMATS and INFORMATS in SAS
Sometimes while reading and viewing a dataset we can have differences. All this is due to formats and informats.
Ekta Aggarwal
- Jan 21, 2021
PROC APPEND - appending data vertically
PROC APPEND is used to append data vertically in SAS in an already existing dataset.
Ekta Aggarwal
- Jan 21, 2021
WHERE Statement in SAS
In SAS 'WHERE' keyword is used to retrieve those rows in a dataset which satisfy a particular condition.
Ekta Aggarwal
- Jan 20, 2021
DATA _NULL_ and PUT - printing output in log
Sometime in a code you don't want to create a dataset rather than want to see the output of something in log.
Ekta Aggarwal
- Jan 20, 2021
INTNX - Incrementing dates in SAS
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.
Ekta Aggarwal
- Jan 20, 2021
INTCK- Comparing two dates in SAS
In SAS, INTCK is used to compare two dates and returns the difference between them. We shall learn about it in depth.
Ekta Aggarwal
- Jan 20, 2021
Creating or reading datasets in SAS
In this tutorial we shall learn how to create or read datasets in SAS along with comma, decimal, colon informats and formats.
Ekta Aggarwal
- Jan 20, 2021
YEARCUTOFF option in dates
YEARCUTOFF is an important parameter in reading and defining dates in SAS which can affect the dates by a CENTURY.
Ekta Aggarwal
- Jan 20, 2021
Dates in SAS
SAS has got various dates formats and informats. In this tutorial we shall understand all of them in detail and how they are used.
Ekta Aggarwal
- Jan 20, 2021
FIRSTOBS and OBS in SAS
In this tutorial we shall learn about FIRSTOBS and OBS in SAS with detailed examples.
Ekta Aggarwal
- Jan 15, 2021
EXPORTING CSV , TXT and EXCEL files from SAS
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.
Ekta Aggarwal
- Jan 15, 2021
EXPORTING multiple datasets in one excel in different sheets in SAS
In this tutorial we shall learn about how to export various datasets in a single excel (each data in a single sheet) in SAS.
Ekta Aggarwal
- Jan 15, 2021
IMPORTING data in SAS (using PROC IMPORT)
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
Ekta Aggarwal
- Jan 15, 2021
IF ELSE in SAS (Creation of new variables and Filtering data)
In this tutorial we shall learn about how to do data manipulations and filter rows using IF ELSE in SAS.