Returns the number of missing numeric values. Returns the number of nonmissing numeric values. Returns the kth largest nonmissing value. Returns the difference in years between two dates according to specified day count conventions returns a person’s age. Returns the current date as a numeric SAS date value.įrom a SAS date value, returns an integer that corresponds to the day of the week.

Returns the quarter of the year from a SAS date value. Returns a SAS date value from month, day, and year values. Increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value. Returns the number of interval boundaries of a given kind that lie between two dates, times, or datetime values. Removes trailing blanks from a character string, and returns one blank if the string is missing.Ĭonverts all letters in an argument to uppercase.Įxtracts the date from a SAS datetime value. Replaces all occurrences of a substring in a character string. Returns the nth word from a character string. Returns the length of a non-blank character string, excluding trailing blanks, and returns 1 for a blank character string.Ĭonverts all letters in an argument to lowercase.Ĭonverts all words in an argument to proper case. Searches for a specific substring of characters within a character string. Returns a character string with specified characters removed from the original string. Removes multiple blanks from a character string. Removes leading and trailing blanks, inserts delimiters, and returns a concatenated character string. Removes leading and trailing blanks, and returns a concatenated character string. After putting the request out to my fellow instructors world-wide, these are our collective favorites: Categoryĭoes not remove leading or trailing blanks, and returns a concatenated character string. I was asked to consolidate the LONG list into a more accessible list of favorites. With so many functions available, it is easy for a new programmer to get overwhelmed. I felt a little better when none of them had heard of it either! As a new instructor, I was a bit embarrassed I had never heard of the SPEDIS function, so at a break I asked the other three local instructors, who probably had a combined 50+ years of SAS experience. I remember the first time this happened, a student told me he thought the SPEDIS function was the greatest thing in SAS.

I’ve taught SAS programming courses for 15 years, and I’ll admit that occasionally my students will ask me about a particular function that I have honestly never heard of. Last time I checked, there are well over 500 functions and call routines in SAS.

Sas geodist function