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
The INTCK function in SAS returns the number of interval boundaries that lie between two SAS dates, times, or timestamp values. It’s a super powerful function in SAS which is being used widely when calculating date intervals between two dates. Syntax of INTCK function: INTCK(interval , start-date-time, end-date-time, <'method'>) INTCK(interval , start-date-time, end-date-time, <‘method’>) method: … Read more
The INTCK function in SAS returns the number of interval boundaries that lie between two SAS dates, times, or timestamp values. It’s a super powerful function in SAS which is being used in many various ways. I have seen it being used extensively in the where clause where you filter out the data by calculating … Read more
SAS gives you more flexibility to write a SAS code and create new datasets with keeping or dropping specific variables (columns) from a base dataset. We have two SAS options DROP= and KEEP= which we can use to have more controls on column level while reading and creating sas datasets. Things will be more clear … Read more
The basic SQL concept is still the same in SAS. The DELETE statement deletes only the rows (data) in a table. The DROP TABLE statement removes the table from the database completely, including the table structure. DELETE Statement in SAS This is the most commonly used statement to remove a few, specific groups of observations, … Read more
In this post you’ll learn how to delete datasets in SAS using 3 simple ways. It also explains how you can drop the entire SAS dataset and/or entire data from a specific library. Short Summary: Delete table v/s Drop table The DELETE statement deletes only the rows (data) in a table. The DROP TABLE statement … Read more
You might have encountered the following error when loading, updating to re-creating a sas data set. “File WORK.XXXX.DATA is damaged. I/O processing did not complete” ERROR: File OLRSAS.RESULT.DATA is damaged. I/O processing did not complete. This is a most common situation where you need to repair a damaged data set: A system failure occurs while … Read more
SAS Studio is getting more popular than ever since it has launched. This is because of the boom in cloud technology and upcoming web migration. The SAS Studio bundled with the SAS Viya is the perfect solution delivered by SAS and they are making improvements with each patch or a new version. You may have … Read more