Ekta AggarwalJan 23, 2021PROC SQL - Run SQL queries from RIf 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.
Ekta AggarwalJan 22, 2021PROC 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 AggarwalJan 22, 2021Merging data in SASDatasets 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 AggarwalJan 21, 2021PROC SORT in SASPROC SORT is a very powerful procedure in SAS to sort the dataset at multiple levels and removing the duplicates.
Ekta AggarwalJan 21, 2021Difference between WHERE and IF in SASBoth IF and WHERE keywords are used to filter the datasets but not both of them can be used in all the situations.
Ekta AggarwalJan 21, 2021String functions in SASSAS offers plethora of functions for string manipulations. In this tutorial we shall learn about them in detail.
Ekta AggarwalJan 21, 2021PROC 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 AggarwalJan 20, 2021FORMATS and INFORMATS in SASSometimes while reading and viewing a dataset we can have differences. All this is due to formats and informats.
Ekta AggarwalJan 20, 2021PROC APPEND - appending data verticallyPROC APPEND is used to append data vertically in SAS in an already existing dataset.
Ekta AggarwalJan 20, 2021WHERE Statement in SASIn SAS 'WHERE' keyword is used to retrieve those rows in a dataset which satisfy a particular condition.
Ekta AggarwalJan 20, 2021DATA _NULL_ and PUT - printing output in logSometime in a code you don't want to create a dataset rather than want to see the output of something in log.
Ekta AggarwalJan 20, 2021INTNX - Incrementing dates in SASTo 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 AggarwalJan 20, 2021INTCK- Comparing two dates in SASIn SAS, INTCK is used to compare two dates and returns the difference between them. We shall learn about it in depth.
Ekta AggarwalJan 20, 2021Creating or reading datasets in SASIn this tutorial we shall learn how to create or read datasets in SAS along with comma, decimal, colon informats and formats.
Ekta AggarwalJan 20, 2021YEARCUTOFF option in datesYEARCUTOFF is an important parameter in reading and defining dates in SAS which can affect the dates by a CENTURY.
Ekta AggarwalJan 20, 2021Dates in SASSAS has got various dates formats and informats. In this tutorial we shall understand all of them in detail and how they are used.
Ekta AggarwalJan 20, 2021FIRSTOBS and OBS in SASIn this tutorial we shall learn about FIRSTOBS and OBS in SAS with detailed examples.
Ekta AggarwalJan 15, 2021EXPORTING CSV , TXT and EXCEL files from SASIn 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 AggarwalJan 15, 2021EXPORTING multiple datasets in one excel in different sheets in SASIn this tutorial we shall learn about how to export various datasets in a single excel (each data in a single sheet) in SAS.
Ekta AggarwalJan 15, 2021IMPORTING 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 AggarwalJan 15, 2021IF 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.