sas functions

Scan function sas

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.

sas index function

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.

SAS Length Function

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.

intck in sas

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.

fuzzy matching in sas

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.

Receive the latest articles in your inbox

Insert your email signup form below

🤞 Don’t miss these tips!

We don’t spam! Read more about our privacy policy.