IFC and IFN Functions in SAS
When an expression is evaluated using IFC and IFN functions, a true or false … Read more
How to use the SAS SCAN Function?
SCAN and SCANQ split strings into words. Both functions are similar. However, the SCANQ function has some additional features, and there is a difference in the default delimiter used in these two functions.
The SAS Index Function Explained
The INDEX function is used to search for a specified string of characters. If any match is found, INDEX function returns 0 or the position of the first occurrence of the string’s first character.
Length functions in SAS : LENGTH / LENGTHN / LENGTHC / LENGTHM.
SAS Length Function: LENGTH is a character function in SAS used to find the length of the character string. There are 4 variations available in SAS to find the length of a string. These are the LENGTH, LENGTHN, LENGTHC and LENGTHM. The primary objective of all the length function is to return the length of the string however there are few variations in how these functions work and return the length.
The Ultimate Guide to SUBSTR in SAS
The SUBSTR in SAS is used to extract part of the string. But apart form extracting parts of a string it has got another important use as well.
Date Interval Functions – INTNX and INTCK in SAS
The SAS data interval functions INTNX and INTCK used to perform calculations on a date, DateTime values, and time intervals. INTNX is used to increment SAS date by a specified and INTCK function returns the number of interval boundaries between two dates, times, or DateTime values.
Date Functions in SAS – The Definitive Guide
The date functions in SAS are used to create date, time or DateTime values, Extract part of a date, Computing interval between two dates.
4 Functions for fuzzy matching in SAS
Fuzzy matching in SAS is a technique of deciding programmatically if one word is identical to the other. For example, deciding if ‘John Doe’ is identical to ‘Johnny Doe’. In SAS, there are a number of functions that will let you carry out a fuzzy match.
Using the Compare function in SAS for comparing strings
The COMPARE function in SAS lets you compare two-character values and with optionally available modifiers, you’ll be able to ignore cases and truncate a longer value to the length of a shorter value before making the comparison.
Receive the latest articles in your inbox
Insert your email signup form below
