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 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.
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 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.
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.
The date functions in SAS are used to create date, time or DateTime values, Extract part of a date, Computing interval between two dates.
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.
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