0% found this document useful (0 votes)
33 views

Base Programming Ref Sheet

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
33 views

Base Programming Ref Sheet

Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

• •




• •

• •







o
o •
o •








• •


• •
• •








• •











• Function What is does



MDY(month, day, year) Creates a SAS Date Value
TODAY() Returns the current date as a numeric SAS

date value

• YEAR(date-var); Returns Year/Month/Day/QTR of the sas
MONTH(date-var) date value input
• DAY(date-var)
QTR(date-var)
INTCK(interval, start- Increments a date/time/datetime value by
from, increment) a given time interval

Function What is does

• TRIM(string) Removes trailing blanks

• STRIP(string) Removes all leading and trailing blanks

SCAN(string, count, Returns the nth word from a string



<char-list, <modifier>>)
•  PROPCASE(string) Changes the casing of the string.
•  UPCASE(string) Commonly used in statements of equality
• LOWCASE(string)

SUBSTR(string, start- Extracts a substring from the argument


from, length)

• •





• •
Function What is does

RAND(‘distribution, Generates random numbers from a
paramter1,...) selected distribution •
ROUND(number, Rounds number to the nearest
<rounding unit>) rounding unit (.01, .001, etc)

LARGEST(k, value1, Returns the Kth largest non missing


value2, …) value

SUM(argument1, Sums all non missing arguments


argument2,…)
• •

• •

• •
• •

• •



You might also like