/* https://support.sas.com/en/documentation.html */
/* SAS Viya 2024.06 https://go.documentation.sas.com/doc/en/pgmsascdc/v_052/pgmsaswlcm/home.htm */
/* SAS 9.4 / Viya 3.5 https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/pgmsashome/home.htm */
/*! keywords ======================================================== */
/* Operators */
/* https://go.documentation.sas.com/doc/en/pgmsascdc/v_052/lepg/titlepage.htm */
eq ne gt lt ge le in
and or not
min max
/* Global Statements */
/* https://go.documentation.sas.com/doc/en/pgmsascdc/v_052/lestmtsglobal/titlepage.htm */
catname
checkpoint execute_always
endsas
filename
footnote
libname
lock
missing
options
page
resetline
run
sasfile
skip
sysecho
title
/* DATA Step Statements */
/* https://go.documentation.sas.com/doc/en/pgmsascdc/v_052/lestmtsref/titlepage.htm */
abort
array
attrib
by
call
cards
cards4
continue
data
datalines
datalines4
delete
describe
do until while
drop
end
error
execute
file
format
goto
if then else
infile
informat
input
keep
label
leave
length
link
list
lockdown
lostcard
merge
modify
output
put
putlog
redirect
remove
rename
replace
retain
return
select when otherwise
set
stop
update
where
/* SQL Procedure */
/* https://go.documentation.sas.com/doc/en/pgmsascdc/v_052/sqlproc/titlepage.htm */
proc
alter table
connect
create index
create table
create view
delete
describe table
describe view
describe table constraints
disconnect from
drop table
drop view
drop index from
execute by
from
group by
having
insert into set
insert into values
order by asc desc
quit
reset
select distinct unique
update where
validate
where
/*! macro ======================================================== */
/* Macro Language */
/* https://go.documentation.sas.com/doc/en/pgmsascdc/v_052/mcrolref/titlepage.htm */
%include
%list
%run
/* Macro Statements */
%abort
%copy
%do %to %until %while
%end
%global
%goto
%if %then %else
%let
%local
%macro
%mend
%put
%return
%symdel
%syscall
%sysexec
%syslput
%sysmacdelete
%sysmstoreclear
%sysrput
/* AutoCall Macros */
%cmpres(text | text-expression)
%compstor(pathname=sas-data-library)
%datatyp(text | text-expression)
%kverify(source, excerpt)
%left(text | text-expression)
%lowcase(text | text-expression)
%qcmpres(text | text-expression)
%qleft(text | text-expression)
%qlowcase(text | text-expression)
%qtrim(text | text-expression)
%sysrc(character-string)
%trim(text | text-expression)
%verify(source, excerpt)
/* Macro Functions */
%bquote(character-string)
%eval(expression)
%index(source-string, target-string)
%length(character-string)
%nrbquote(character-string)
%nrquote(character-string)
%nrstr(character-string)
%qscan(character-string, n<, charlist<, modifiers>>)
%qsubstr(character-string, position<, length>)
%qsysfunc(function(s)<, format>)
%quote(character-string)
%qupcase(character-string)
%scan(character-string, n<, delimiters<, modifiers>>)
%str(character-string)
%substr(character-string, position<, length>)
%superq(macro-variable-name)
%symexist(macro-variable-name)
%symglobl(macro-variable-name)
%symlocal(macro-variable-name)
%sysevalf(expression<, conversion-type>)
%sysfunc(function(s)<, format>)
%sysget(environment-variable)
%sysmacexec(macro-name)
%sysmacexist(macro-name)
%sysmexecdepth
%sysmexecname(nesting-level)
%sysprod(product-code)
%unquote(character-string)
%upcase(character-string)
/* Base SAS Utilities */
%ds2csv(argument-1=value-1, argument-2=value-2 <,argument-3=value-3 ...>)
%tslit(literal text)
/*! functions ======================================================== */
/* Functions and CALL Routines */
/* https://go.documentation.sas.com/doc/en/pgmsascdc/v_052/lefunctionsref/titlepage.htm */
abs()
addrlong()
airy()
allcomb()
allperm()
anyalnum()
anyalpha()
anycntrl()
anydigit()
anyfirst()
anygraph()
anylower()
anyname()
anyprint()
anypunct()
anyspace()
anyupper()
anyxdigit()
arcos()
arcosh()
arsin()
arsinh()
artanh()
atan()
atan2()
attrc()
attrn()
band()
beta()
betainv()
bhamming_32()
bhamming_hex()
blackclprc()
blackptprc()
blkshclprc()
blkshptprc()
blshift()
bnot()
bor()
brshift()
bxor()
byte()
call allcomb()
call allcombi()
call allperm()
call cats()
call catt()
call catx()
call compcost()
call execute()
call graycode()
call is8601_convert()
call label()
call lexcomb()
call lexcombi()
call lexperk()
call lexperm()
call logistic()
call missing()
call module()
call pokelong()
call prxchange()
call prxdebug()
call prxfree()
call prxnext()
call prxposn()
call prxsubstr()
call ranbin()
call rancau()
call rancomb()
call ranexp()
call rangam()
call rannor()
call ranperk()
call ranperm()
call ranpoi()
call rantbl()
call rantri()
call ranuni()
call scan()
call set()
call sleep()
call softmax()
call sort()
call sortc()
call sortn()
call stdize()
call stream()
call streaminit()
call streamrewind()
call symput()
call symputx()
call system()
call tanh()
call vname()
call vnext()
cat()
catq()
cats()
catt()
catx()
cdf()
ceil()
ceilz()
cexist()
char()
choosec()
choosen()
cinv()
clibexist()
close()
cmiss()
cnonct()
coalesce()
coalescec()
collate()
comb()
compare()
compbl()
compfuzz()
compfuzz_miss()
compged()
complev()
compound()
compress()
compsrv_oval()
compsrv_unquote2()
constant()
convx()
convxp()
cos()
cosh()
cot()
count()
countc()
countw()
csc()
css()
cumipmt()
cumprinc()
curobs()
cv()
daccdb()
daccdbsl()
daccsl()
daccsyd()
dacctab()
dairy()
datdif()
date()
datejul()
datepart()
datetime()
day()
dclose()
dcreate()
depdb()
depdbsl()
depsl()
depsyd()
deptab()
dequote()
deviance()
dhms()
dif()
digamma()
dim()
dinfo()
divide()
dlgcdir()
dnum()
dopen()
doptname()
doptnum()
dosubl()
dread()
dropnote()
dsname()
dur()
durp()
effrate()
envlen()
erf()
erfc()
euclid()
exist()
exp()
expm1()
fact()
fappend()
fclose()
fcol()
fcopy()
fdelete()
fetch()
fetchobs()
fexist()
fget()
fileexist()
filename()
fileref()
finance()
find()
findc()
findw()
finfo()
finv()
fipname()
fipnamel()
fipstate()
first()
floor()
floorz()
fmtinfo()
fnonct()
fnote()
fopen()
foptname()
foptnum()
fpoint()
fpos()
fput()
fread()
frewind()
frlen()
fsep()
fuzz()
fwrite()
gaminv()
gamma()
garkhclprc()
garkhptprc()
gcd()
geodist()
geomean()
geomeanz()
getcasurl()
getlcaslib()
getlsessref()
getsessopt()
getltag()
getoption()
getvarc()
getvarn()
graycode()
harmean()
harmeanz()
hash_fast_hex()
hash_xx_hex()
hashing()
hashing_file()
hashing_hmac()
hashing_hmac_file()
hashing_hmac_init()
hashing_init()
hashing_part()
hashing_term()
hbound()
hms()
holiday()
holidayck()
holidaycount()
holidayname()
holidaynx()
holidayny()
holidaytest()
hour()
htmldecode()
htmlencode()
ibessel()
ifc()
ifn()
index()
indexc()
indexw()
input()
inputc()
inputn()
int()
intcindex()
intck()
intcycle()
intfit()
intfmt()
intget()
intindex()
intnx()
intrr()
intseas()
intshift()
inttest()
intz()
iorcmsg()
ipmt()
iqr()
irr()
jbessel()
jsonpp()
juldate()
juldate7()
kurtosis()
lag()
largest()
lbound()
lcm()
lcomb()
left()
length()
lengthc()
lengthm()
lengthn()
lexcomb()
lexcombi()
lexperk()
lexperm()
lfact()
lgamma()
libname()
libref()
log()
log10()
log1px()
log2()
logbeta()
logcdf()
logistic()
logpdf()
logsdf()
lowcase()
lperm()
lpnorm()
mad()
margrclprc()
margrptprc()
max()
md5()
mdy()
mean()
median()
min()
minute()
missing()
mod()
modexist()
module()
modulec()
modulen()
modz()
month()
mopen()
mort()
msplint()
mvalid()
n()
netpv()
nliteral()
nmiss()
nomrate()
normal()
notalnum()
notalpha()
notcntrl()
notdigit()
note()
notfirst()
notgraph()
notlower()
notname()
notprint()
notpunct()
notspace()
notupper()
notxdigit()
npv()
nvalid()
nwkdom()
open()
ordinal()
pathname()
pctl()
pdf()
peekclong()
peeklong()
perm()
pmt()
point()
poisson()
ppmt()
probbeta()
probbnml()
probbnrm()
probchi()
probf()
probgam()
probhypr()
probit()
probmc()
probmed()
probnegb()
probnorm()
probt()
propcase()
prxchange()
prxmatch()
prxparen()
prxparse()
prxposn()
ptrlongadd()
put()
putc()
putn()
pvp()
qtr()
quantile()
quote()
ranbin()
rancau()
rand()
ranexp()
rangam()
range()
rank()
rannor()
ranpoi()
rantbl()
rantri()
ranuni()
rename()
repeat()
resolve()
reverse()
rewind()
right()
rms()
round()
rounde()
roundz()
saving()
savings()
scan()
sdf()
sec()
second()
sessbusy()
sessfound()
sha256()
sha256hex()
sha256hmachex()
sign()
sin()
sinh()
skewness()
sleep()
smallest()
sort()
soundex()
spedis()
sqrt()
squantile()
std()
stderr()
stfips()
stname()
stnamel()
strip()
subpad()
substr()
substrn()
sum()
sumabs()
symexist()
symget()
symglobl()
symlocal()
sysexist()
sysget()
sysmsg()
sysparm()
sysprocessid()
sysprocessname()
sysprod()
sysrc()
system()
tan()
tanh()
time()
timepart()
timevalue()
tinv()
tnonct()
today()
translate()
transtrn()
tranwrd()
trigamma()
trim()
trimn()
trunc()
tslvl()
typeof()
tzoneid()
tzonename()
tzoneoff()
tzones2u()
tzoneu2s()
uniform()
upcase()
urldecode()
urlencode()
uss()
uuidgen()
var()
varfmt()
varinfmt()
varlabel()
varlen()
varname()
varnum()
varray()
varrayx()
vartype()
verify()
vformat()
vformatd()
vformatdx()
vformatn()
vformatnx()
vformatw()
vformatwx()
vformatx()
vinarray()
vinarrayx()
vinformat()
vinformatd()
vinformatdx()
vinformatn()
vinformatnx()
vinformatw()
vinformatwx()
vinformatx()
vlabel()
vlabelx()
vlength()
vlengthx()
vname()
vnamex()
vtype()
vtypex()
vvalue()
vvaluex()
week()
weekday()
whichc()
whichn()
year()
yieldp()
yrdif()
yyq()
zipcity()
zipcitydistance()
zipfips()
zipname()
zipnamel()
zipstate()
/* DATA Step Functions for Macros */
resolve()
symexist()
symget()
symgetn()
symglobl()
symlocal()