The Datalines statement along with the INPUT statement is used to create a data set from scratch by entering data directly in the program, rather than data stored in an external file. You can use only one DATALINES statement in a DATA step. Use separate DATA steps to enter multiple sets of data. Basic Syntax … Read more
The ALTER TABLE statement is used to add new variables, delete existing variables, or modify format of variables. This method gives you more flexibility while adding new variables or modifying existing ones. It is also possible to add values on those newly added columns with UPDATE TABLE statement. The following example demonstrates that two new … Read more
The recommended ways to create new variables in SAS are to use the following methods. Depending on your requirement and use cases you can choose the method best suited to you but all of them are quick and easy to create variables in SAS data set. How to Create New Variables in SAS Data Set … Read more
You have a SAS data set with few numeric variables and most of them are character variables. Now you want to convert those character variables into numeric variables in the SAS data set. In this article we have covered how to convert numeric variables into character variables and vice versa. In this article you’ll learn … Read more
In this article we’re going to deep dive into the most common question from SAS users. I’m sure you also have the same question on how to convert variable values from character to numeric in SAS. On multiple occasions you do need to perform the data value conversion especially when you’re reading data from different … Read more
In this article we’re going to deep dive into the most common question from SAS users. I’m sure you’re also wondering how to convert variable values from numeric to character in SAS. On multiple occasions you do need to perform the data value conversion especially when you’re reading data from different sources. The multiple sources … Read more
SAS has a really interesting function known as INTNX. You can use this function to control the dates and get desired value by passing proper arguments in the INTNX function. SAS INTNX Function: The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, and MINUTE, or a custom … Read more
SAS has a really interesting function INTNX where you can control dates and it can be used to get any desired value from dates. Furthermore you can easily assign that value to the macro variable. SAS INTNX Function: The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, … Read more
The WEEKDAY function produces an integer that represents the day of the week, where 1 = Sunday, 2 = Monday, …, 7 = Saturday. Basic Syntax: WEEKDAY(<date>); WEEKDAY(<date>); Here is the complete table of how the weekday function returns the values. Sunday 1 Monday 2 Tuesday 3 Wednesday 4 Thursday 5 Friday 6 Saturday 7 … Read more
In SAS, dates are stored in numeric and days are calculated by considering the default cut off date which is January 01, 1960 and the date specified. When you’re dealing with SAS dates and calculating time or days, the cut off date is very important. To calculate age you need two values, the first is … Read more