WPS Reference for
Language Elements
"Look up the syntax of language elements
supported by the World Programming
System (WPS)."
Version: 3.1.5 Copyright © 2002-2017 World Programming Limited www.worldprogramming.com
Contents
How to Read EBNF Notation and Syntax Diagrams... 39
WPS Core... 42
Components...42
HASH Component...42
HITER Component...46
JAVAOBJ Component... 47
DATA Step Functions and CALL Routines...49
ABS... 49
ADDR... 49
ADDRLONG... 49
ADDRLONGX...49
ADDRX...50
AIRY... 50
ANYALNUM...50
ANYALPHA...50
ANYCNTRL... 50
ANYDIGIT...50
ANYFIRST...50
ANYGRAPH... 51
ANYLOWER...51
ANYNAME...51
ANYPRINT... 51
ANYPUNCT...51
ANYSPACE... 51
ANYUPPER...51
ANYXDIGIT... 52
APPSRVGETC... 52
APPSRVGETN... 52
APPSRVSET... 52
APPSRV_AUTHCLS... 52
APPSRV_AUTHDS... 52
APPSRV_AUTHLIB...53
APPSRV_HEADER... 53
APPSRV_SESSION... 53
APPSRV_SET... 53
APPSRV_UNSAFE... 53
ARCOS...53
ARCOSH... 54
ARSIN...54
ARTANH... 54
ARTAN...54
ATAN2...54
ATTRC...54
ATTRN...55
BAND...56
BETA... 56
BETAINV... 56
BLACKCLPRC...57
BLACKPTPRC...57
BLKSHCLPRC...57
BLKSHPTPRC...57
BLSHIFT...57
BNOT...57
BOR...58
BRSHIFT... 58
BXOR... 58
BYTE... 58
CALL CATS...58
CALL CATT...58
CALL CATX...58
CALL COMPCOST... 59
CALL EXECUTE... 59
CALL ISPEXEC...59
CALL IS8601_CONVERT... 60
CALL ISPLINK... 60
CALL LABEL...60
CALL LOGISTIC... 60
CALL MISSING...60
CALL MODULE...60
CALL POKE... 61
CALL POKELONG...61
CALL PRXCHANGE... 61
CALL PRXDEBUG...61
CALL PRXFREE... 61
CALL PRXNEXT... 61
CALL PRXPOSN...62
CALL PRXSUBSTR... 62
CALL RANBIN...62
CALL RANCAU...62
CALL RANEXP... 62
CALL RANGAM... 62
CALL RANNOR...62
CALL RANPERK...63
CALL RANPERM... 63
CALL RANPOI... 63
CALL RANTBL...63
CALL RANTRI...63
CALL RANUNI... 63
CALL SCAN... 63
CALL SCANQ... 64
CALL SET... 64
CALL SLEEP...64
CALL SORTC...64
CALL SORTN...64
CALL SOUND... 64
CALL STREAMINIT... 64
CALL SYMDEL... 65
CALL SYMPUT... 65
CALL SYSTEM... 65
CALL TANH...65
CALL VNAME... 65
CALL VNEXT... 65
CAT...65
CATQ...66
CATS... 66
CATT... 66
CATX... 66
CDF... 66
CEIL...69
CEILZ... 69
CEXIST...69
CHAR... 69
CHOOSEC... 69
CHOOSEN... 69
CLOSE... 69
CMISS... 70
COALESCE...70
COALESCEC... 70
COLLATE... 70
COMB...70
COMPARE...70
COMPOUND... 70
COMPBL... 71
COMPGED...71
COMPLEV...71
COMPRESS...71
CONSTANT... 72
CONTAINS... 72
CONVX...72
CONVXP... 72
COSH... 73
COUNT...73
COUNTC... 73
COUNTW... 73
CSS... 73
CUMIPMT...73
CUMPRINC... 74
CUROBS... 74
CV...74
DACCDB... 74
DACCDBSL...74
DACCSL...74
DACCSYD...74
DACCTAB...75
DAIRY...75
DATDIF...75
DATE... 75
DATEJUL...75
DATEPART...75
DATETIME...76
DAY... 76
DCLOSE...76
DCREATE...76
DEPDB... 76
DEPDBSL...76
DEPSL...76
DEPSYD...77
DEPTAB... 77
DEQUOTE...77
DEVIANCE... 77
DHMS...77
DIF...77
DIGAMMA... 77
DIM... 78
DINFO... 78
DNUM...78
DOPEN...78
DOPTNUM... 78
DOPTNAME... 78
DREAD...78
DROPNOTE... 79
DSNAME... 79
DSNCATLGD...79
DUR...79
DURP... 79
EFFRATE... 79
ENCODCOMPAT...80
ENCODISVALID... 80
ENVLEN... 80
ERF... 80
ERFC...80
EUCLID... 80
EXIST... 80
EXP... 81
FACT... 81
FCLOSE... 81
FCOL... 81
FDELETE... 81
FETCH...81
FETCHOBS...81
FEXIST... 82
FGET... 82
FILEEXIST...82
FILENAME...82
FILEREF...82
FINANCE...82
FIND... 90
FINDC...90
FINFO...90
FINV... 90
FIPNAME...90
FIPNAMEL...90
FIPSTATE...91
FIRST... 91
FLOOR... 91
FLOORZ...91
FOPEN... 91
FOPTNAME...91
FOPTNUM...91
FNOTE... 92
FPOINT... 92
FPOS...92
FPUT... 92
FREAD... 92
FREWIND...92
FRLEN...92
FSEP... 92
FUZZ... 93
FWRITE...93
GAMINV... 93
GAMMA...93
GARKHPTPRC...93
GCD...93
GEODIST... 94
GEOMEAN... 94
GEOMEANZ...94
GETLOCENV... 94
GETOPTION... 94
GETPXLANGUAGE... 94
GETPXLOCALE... 94
GETPXREGION... 95
GETVARC... 95
GETVARN... 95
HARMEAN...95
HARMEANZ... 95
HBOUND...95
HMS...95
HOUR...96
HTMLDECODE... 96
HTMLENCODE... 96
IBESSEL...96
IFC...96
IFN...96
INDEX...96
INDEXC...97
INDEXW... 97
INPUT...97
INPUTC... 97
INPUTN... 97
INT...97
INTZ...97
INTCK...98
INTNX...98
INTRR...98
IORCMSG... 98
IPMT... 98
IQR... 99
IRR... 99
JBESSEL...99
JULDATE...99
JULDATE7...99
KCOMPARE... 99
KCOMPRESS...99
KCOUNT... 100
KINDEX... 100
KINDEXC...100
KLEFT... 100
KLENGTH...100
KLOWCASE... 100
KREVERSE...100
KRIGHT...100
KSCAN... 101
KSTRCAT... 101
KSUBSTR...101
KSUBSTRB... 101
KTRANSLATE... 101
KTRIM... 101
KTRUNCATE...101
KUPCASE... 102
KUPDATE...102
KUPDATEB... 102
KURTOSIS... 102
KVERIFY... 102
LARGEST...102
LAG... 102
LBOUND...103
LCOMB...103
LCM...103
LEFT...103
LENGTH...103
LENGTHC... 103
LENGTHM...103
LENGTHN... 104
LFACT... 104
LGAMMA...104
LIBNAME...104
LIBREF...104
LIKE...104
LOG...104
LOG2...105
LOG10...105
LOG1PX... 105
LOGBETA...105
LOGCDF...105
LOGPDF...105
LOGSDF...105
LOOKSLIKENUMBER...106
LOWCASE...106
LPERM... 106
LPNORM... 106
MAD...106
MARGRCLPRC...106
MAX...107
MAXC... 107
MD5...107
MDY...107
MEAN... 107
MEDIAN...107
MIN... 107
MINC... 108
MINUTE...108
MISSING... 108
MOD... 108
MODZ...108
MODULEC...108
MODULEN...108
MONTH... 109
MOPEN... 109
MORT... 109
N... 109
NETPV...109
NLDATE...109
NLDATM... 109
NLITERAL... 110
NLTIME...110
NMISS... 110
NOMRATE...110
NORMAL... 110
NOTALNUM...110
NOTALPHA... 111
NOTCNTRL...111
NOTDIGIT... 111
NOTE...111
NOTFIRST...111
NOTGRAPH... 111
NOTLOWER...111
NOTNAME...112
NOTPRINT... 112
NOTPUNCT...112
NOTSPACE... 112
NOTUPPER...112
NOTXDIGIT...112
NPV... 112
NVALID...113
OPEN... 113
ORDINAL...113
PATHNAME... 113
PCTL... 114
PEEK...114
PEEKC... 114
PEEKCLONG... 114
PEEKLONG...114
PERM... 114
PMT... 115
POINT...115
POISSON... 115
POW... 115
PPMT...115
PROBBETA... 115
PROBBNML... 115
PROBBNRM...116
PROBCHI... 116
PROBF... 116
PROBGAM... 116
PROBHYPR... 116
PROBIT... 116
PROBNEGB... 116
PROBNORM... 116
PROBT... 117
PROPCASE...117
PRXCHANGE...117
PRXMATCH...117
PRXPAREN... 117
PRXPARSE... 117
PRXPOSN...117
PTRLONGADD...118
PUT... 118
PUTC...118
PUTN...118
PVP... 118
QUANTILE...118
QTR... 118
QUOTE...119
RANBIN...119
RANCAU... 119
RAND... 119
RANEXP...125
RANGAM...125
RANGE...125
RANK...125
RANNOR...125
RANPOI...125
RANTBL... 126
RANUNI...126
REPEAT... 126
RESOLVE...126
REVERSE... 126
REWIND...126
RIGHT... 126
RMS...127
ROUND... 127
ROUNDE...127
ROUNDZ... 127
SAVING... 127
SAVINGS...127
SCAN...128
SCANQ...128
SDF... 128
SECOND... 128
SIGN...128
SIN...128
SINH...128
SKEWNESS... 129
SLEEP...129
SMALLEST...129
SOUNDEX...129
SOUNDSLIKE... 129
SPEDIS... 129
SQRT...129
STD... 130
STDERR...130
STFIPS...130
STNAME...130
STNAMEL...130
STRIP...130
SUBPAD... 130
SUBSTR...131
SUBSTRN... 131
SUM...131
SUMABS... 131
SYMGET... 131
SYMGETN...131
SYMGLOBL...131
SYMLOCAL...132
SYSGET...132
SYSMSG... 132
SYSPARM... 132
SYSPROCESSID... 132
SYSPROCESSNAME... 132
SYSPROD...132
SYSRC... 132
SYSTEM...133
TAN...133
TANH... 133
TIME... 133
TIMEPART...133
TIMEVALUE... 133
TINV... 133
TODAY...134
TRANSLATE...134
TRANSTRN...134
TRANTAB... 134
TRANWRD... 134
TRIGAMMA... 134
TRIM...134
TRIMN... 134
TRUNC...135
UNICODE...135
UNICODEC... 135
UNICODELEN...135
UNIFORM...135
UPCASE...135
USS... 135
URLDECODE...136
URLENCODE...136
UUIDGEN...136
VAR... 136
VARFMT... 136
VARINFMT... 136
VARLABEL... 136
VARLEN... 137
VARNAME... 137
VARNUM... 137
VARRAY... 137
VARRAYX...137
VARTYPE... 137
VFORMAT... 137
VFORMATD...137
VFORMATDX... 138
VFORMATN...138
VFORMATNX... 138
VFORMATW...138
VFORMATWX... 138
VFORMATX...138
VINARRAYX... 138
VINFORMAT...139
VINFORMATD... 139
VINFORMATDX...139
VINFORMATN... 139
VINFORMATNX...139
VINFORMATW... 139
VINFORMATWX...139
VINFORMATX... 139
VLABEL...140
VLABELX...140
VLENGTH...140
VLENGTHX... 140
VNAME...140
VNAMEX... 140
VTRANSCODE...140
VTRANSCODEX... 140
VTYPE...141
VTYPEX... 141
VVALUE...141
VVALUEX... 141
VERIFY...141
WEEK...141
WEEKDAY...141
WHICHC...142
WHICHN...142
YEAR...142
YIELDP...142
YRDIF...142
YYQ... 143
ZIPCITY...143
ZIPCITYDISTANCE...143
ZIPFIPS...143
ZIPNAME...143
ZIPNAMEL...143
ZIPSTATE...143
Data Set Options... 144
BUFNO...144
BUFSIZE... 144
COMPRESS...144
DROP... 145
FILECLOSE...145
FIRSTOBS...145
IN... 145
INDEX...145
KEEP...145
LABEL... 145
OBS... 146
OUTREP...146
POINTOBS... 147
RENAME... 147
REPLACE...147
WHERE... 147
DATA Step Statements...147
_NEW_... 147
ABORT... 148
ARRAY... 148
ATTRIB... 148
BY...148
CALL...149
CARDS...149
CARDS4...149
CONTINUE...149
DATA...149
DATALINES... 150
DATALINES4... 150
DECLARE...150
DELETE...150
DO... 150
DO, iterative... 150
DO UNTIL... 151
DO WHILE... 151
DROP... 151
END...151
ERROR...151
FILE... 151
FORMAT...154
GO TO...154
IF, subsetting...154
IF-THEN/ELSE... 154
INFILE... 155
INFORMAT... 156
INPUT...156
KEEP...158
LABEL... 158
Labels,Statement...158
LEAVE... 158
LENGTH...158
LINK...159
LIST... 159
MERGE... 159
OUTPUT...160
PUT... 160
PUTLOG...162
REMOVE...162
RENAME... 162
REPLACE...163
RETAIN...163
RETURN...163
SELECT...163
SET...164
SKIP... 164
STOP...164
Sum... 164
UPDATE... 165
WHERE... 165
Formats... 165
w.d...165
DOLLARw.d...165
DOLLARXw.d... 165
$w... 165
$ASCIIw...165
$BASE64Xw... 165
$BIDIw... 165
$BINARYw...165
$BYVALw...165
$CHARw...165
$CSTRw... 166
$EBCDICw...166
$Fw...166
$HEXw...166
$LOGVSw...166
$LOGVSRw... 166
$MSGCASEw... 166
$N8601Bw... 166
$N8601BAw...166
$N8601Ew... 166
$N8601EAw...166
$N8601EHw...166
$N8601EXw...166
$N8601Hw...166
$N8601Xw... 166
$OCTALw... 166
$QUOTEw... 166
$REVERJw...166
$REVERSw... 167
$UCS2Bw... 167
$UCS2BEw...167
$UCS2Lw...167
$UCS2LEw... 167
$UCS2Xw... 167
$UCS2XEw...167
$UCS4Bw... 167
$UCS4BEw...167
$UCS4Lw...167
$UCS4LEw... 167
$UCS4Xw... 167
$UCS4XEw...167
$UESCw... 167
$UESCEw...167
$UNCRw...167
$UNCREw... 167
$UPARENw... 167
$UPARENEw... 168
$UPCASEw... 168
$UTF8Xw...168
$UTF8XEw... 168
$VARYINGw... 168
$VSLOGw...168
$VSLOGRw... 168
B8601DAw...168
B8601DNw...168
B8601DTw.d...168
B8601DZw...168
B8601LZw...168
B8601TMw.d...168
B8601TZw... 168
BESTw.d...168
BINARYw...168
COMMAw.d... 168
COMMAXw.d...168
Dw.d...169
DATEw...169
DATEAMPMw.d... 169
DATETIMEw.d... 169
DAYw... 169
DDMMYYw... 169
DDMMYYBw...169
DDMMYYCw...169
DDMMYYDw...169
DDMMYYNw...169
DDMMYYPw...169
DOWNAMEw...169
DTDATEw... 169
DTMONYYw... 169
DTWKDATXw... 169
DTYEARw...169
DTYYQCw... 169
Ew...170
E8601DAw...170
E8601DNw...170
E8601DTw.d...170
E8601DZw...170
E8601LZw...170
E8601TMw.d...170
E8601TZw... 170
EURDFDDw...170
EURDFDEw...170
EURDFDNw...170
EURDFDTw...170
EURDFDWNw... 170
EURDFMNw... 170
EURDFMYw... 170
EURDFWDXw... 170
EURDFWKXw...170
EUROw.d...170
EUROXw.d... 171
Fw... 171
FLOATw.d...171
FRACTw... 171
HDATEw.d... 171
HEBDATEw... 171
HEXw...171
HHMMw.d...171
HOURw.d...171
IBw.d...171
IBRw.d... 171
IEEEw.d...171
JULDATEw... 171
JULDAYw...171
JULIANw...171
MDYAMPMw.d...171
MINGUOw.d... 171
MMDDYYw... 171
MMDDYYBw...172
MMDDYYCw...172
MMDDYYDw...172
MMDDYYNw...172
MMDDYYPw...172
MMDDYYSw...172
MMSSw.d... 172
MMYYw... 172
MMYYCw...172
MMYYDw...172
MMYYNw...172
MMYYPw...172
MMYYSw...172
MONNAMEw... 172
MONTHw...172
MONYYw...172
NEGPARENw.d... 172
NENGOw.d...172
NLBESTw.d... 173
NLDATEw.d... 173
NLDATEMDw.d...173
NLDATEMNw.d...173
NLDATEWw.d...173
NLDATEWNw.d... 173
NLDATEYMw.d...173
NLDATEYRw.d... 173
NLDATMw.d...173
NLDATMAPw.d...173
NLDATMDTw.d...173
NLDATMMDw.d... 173
NLDATMMNw.d... 173
NLDATMTMw.d... 173
NLDATMTZw.d... 173
NLDATMWw.d... 173
NLDATMWZw.d... 173
NLDATMYMw.d... 173
NLDATMYRw.d...174
NLDATMZw.d... 174
NLMNIAEDw.d...174
NLMNIAUDw.d... 174
NLMNIBGNw.d... 174
NLMNIBRLw.d...174
NLMNICADw.d... 174
NLMNICHFw.d...174
NLMNICNYw.d... 174
NLMNICZKw.d...174
NLMNIDKKw.d...174
NLMNIEGPw.d... 174
NLMNIEURw.d... 174
NLMNIHKDw.d... 174
NLMNIHRKw.d... 174
NLMNIHUFw.d...174
NLMNIIDRw.d...174
NLMNIILSw.d...175
NLMNIINRw.d...175
NLMNIJPYw.d... 175
NLMNIKRWw.d...175
NLMNILTLw.d... 175
NLMNILVLw.d...175
NLMNIMOPw.d...175
NLMNIMXNw.d...175
NLMNIMYRw.d...175
NLMNINOKw.d... 175
NLMNINZDw.d...175
NLMNIPLNw.d...175
NLMNIRUBw.d... 175
NLMNISEKw.d...175
NLMNISGDw.d... 175
NLMNITHBw.d...175
NLMNITRYw.d...175
NLMNITWDw.d...175
NLMNIUSDw.d... 176
NLMNIZARw.d...176
NLMNLAEDw.d...176
NLMNLAUDw.d... 176
NLMNLBGNw.d... 176
NLMNLBRLw.d...176
NLMNLCADw.d... 176
NLMNLCHFw.d...176
NLMNLCNYw.d... 176
NLMNLCZKw.d...176
NLMNLDKKw.d...176
NLMNLEGPw.d... 176
NLMNLEURw.d... 176
NLMNLGBPw.d... 176
NLMNLHKDw.d... 176
NLMNLHRKw.d... 176
NLMNLHUFw.d...176
NLMNLIDRw.d...176
NLMNLILSw.d...177
NLMNLINRw.d...177
NLMNLJPYw.d... 177
NLMNLKRWw.d...177
NLMNLLTLw.d... 177
NLMNLLVLw.d...177
NLMNLMOPw.d...177
NLMNLMXNw.d...177
NLMNLMYRw.d...177
NLMNLNOKw.d... 177
NLMNLNZDw.d...177
NLMNLPLNw.d...177
NLMNLRUBw.d... 177
NLMNLSEKw.d...177
NLMNLSGDw.d... 177
NLMNLTHBw.d... 177
NLMNLTRYw.d... 177
NLMNLTWDw.d... 177
NLMNLUSDw.d... 178
NLMNLZARw.d...178
NLMNYw.d...178
NLMNYIw.d...178
NLNUMw.d... 178
NLNUMIw.d... 178
NLPCTw.d... 178
NLPCTIw.d... 178
NLPCTNw.d...178
NLPVALUEw.d...178
NLSTRMONw.d...178
NLSTRQTRw.d...178
NLSTRWKw.d...178
NLTIMAPw.d...178
NLTIMEw.d... 178
NUMXw.d...178
OCTALw... 178
PDw.d... 178
PDJULGw...179
PDJULIw...179
PERCENTw.d...179
PIBw.d... 179
PIBRw.d...179
PKw.d... 179
PVALUEw.d... 179
QTRw...179
QTRRw...179
RBw.d... 179
ROMANw...179
S370FFw.d... 179
S370FIBw.d... 179
S370FIBUw.d...179
S370FPDw.d...179
S370FPIBw.d...179
S370FRBw.d...179
S370FZDw.d...180
S370FZDLw.d...180
S370FZDSw.d... 180
S370FZDTw.d...180
S370FZDUw.d... 180
SSNw...180
TIMEw.d...180
TIMEAMPMw.d...180
TODw.d...180
WEEKDATEw... 180
WEEKDATXw... 180
WEEKDAYw... 180
WEEKUw...180
WEEKVw... 180
WEEKWw... 180
WORDDATEw... 180
WORDDATXw... 180
WORDFw...180
WORDSw... 181
YEARw... 181
YENw.d...181
YYMMw... 181
YYMMCw...181
YYMMDw...181
YYMMDDw... 181
YYMMDDBw...181
YYMMDDCw...181
YYMMDDDw...181
YYMMDDNw...181
YYMMDDPw...181
YYMMDDSw...181
YYMMNw...181
YYMMPw...181
YYMMSw...181
YYMONw...181
YYQw...181
YYQCw...182
YYQDw...182
YYQNw...182
YYQPw... 182
YYQRw...182
YYQRCw... 182
YYQRDw... 182
YYQRNw... 182
YYQRPw...182 YYQRSw...182 YYQSw... 182 YYWEEKUw... 182 YYWEEKVw... 182 YYWEEKWw... 182 Zw.d...182 ZDw.d... 182 Global Statements... 183 Comment... 183 DSNEXST...183 ENDSAS...183 ENDWPS...183 FILENAME...183 FILENAME, DDE Access Method... 184 FILENAME, DISK Access Method...184 FILENAME, EMAIL Access Method... 185 FILENAME, FTP Access Method... 186 FILENAME, HTTP Access Method...187 FILENAME, PIPE Access Method...187 FILENAME, SOCKET Access Method... 188 FILENAME, SYSOUT Access Method... 188 FILENAME, URL Access Method...189 FILENAME, z/OS Data Sets Access Method...190 FOOTNOTE...191
%INCLUDE...193 LIBNAME...193 MISSING... 193 ODS _ALL_ CLOSE... 194 ODS CHTML...194 ODS CSV...194 ODS CSVALL...195 ODS EXCLUDE... 195 ODS HTML...196 ODS HTMLCSS... 199 ODS LISTING... 199 ODS MARKUP...200 ODS OUTPUT...203 ODS PHTML... 203 ODS SELECT... 204 ODS SHOW... 204 ODS TRACE... 204 OPTIONS... 204 PAGE...205 RUN...205
SYSTASK COMMAND...205 SYSTASK LIST... 205 SYSTASK KILL... 206 TITLE...206 WAITFOR... 207 X (on UNIX platforms)... 207 X (on Windows)... 207 X (on z/OS)...207 Informats... 207 w.d...207 DOLLARw.d...207 DOLLARXw.d... 207
$w... 208
$ASCIIw...208
$BASE64Xw... 208
$BINARYw...208
$CHARw...208
$CHARZBw... 208
$CSTRw... 208
$EBCDICw...208
$HEXw...208
$LOGVSw...208
$LOGVSRw... 208
$N8601Bw... 208
$N8601Ew... 208
$PHEXw... 208
$REVERJw...208
$REVERSw... 208
$UCS2Bw... 208
$UCS2BEw...208
$UCS2Lw...209
$UCS2Xw... 209
$UCS2XEw...209
$UCS4Bw... 209
$UCS4Lw...209
$UCS4Xw... 209
$UCS4XEw...209
$UESCw... 209
$UESCEw...209
$UNCRw...209
$UNCREw... 209
$UPARENw... 209
$UPARENEw... 209
$UPCASEw... 209
$UTF8Xw...209
$UTF8XEw... 209
$VARYINGw.d... 209
$VSLOGw...209
$VSLOGRw... 210 ANYDTDTEw...210 ANYDTDTMw... 210 ANYDTTMEw... 210 B8601DAw...210 B8601DNw...210 B8601DTw...210 B8601DZw...210 B8601LZw...210 B8601TMw...210 B8601TZw... 210 BESTw.d...210 BINARYw.d...210 BITSw.d... 210 BZw.d...210 COMMAw.d... 210 COMMAXw.d...210 Dw.d...210 DATEw...211 DATETIMEw... 211 DDMMYYw... 211 Ew.d...211 E8601DAw...211 E8601DNw...211 E8601DTw...211 E8601DZw...211 E8601LZw...211 E8601TMw...211 E8601TZw... 211 EUROw...211 EUROXw... 211 Fw.d...211 FLOATw.d...211 HEXw...211 HHMMSSw... 211 IBw.d...211 IBRw.d... 212 JULIANw...212 MDYAMPMw...212 MINGUOw... 212 MMDDYYw... 212 MONYYw...212 MSECw...212
NLDATEw... 212 NLDATMw...212 NLMNIAEDw...212 NLMNIAUDw... 212 NLMNIBGNw... 212 NLMNIBRLw...212 NLMNICADw... 212 NLMNICHFw...212 NLMNICNYw... 212 NLMNICZKw...212 NLMNIDKKw...213 NLMNIEGPw... 213 NLMNIEURw... 213 NLMNIGBPw... 213 NLMNIHKDw... 213 NLMNIHRKw... 213 NLMNIHUFw...213 NLMNIIDRw...213 NLMNIILSw...213 NLMNIINRw...213 NLMNIJPYw... 213 NLMNIKRWw...213 NLMNILTLw... 213 NLMNILVLw...213 NLMNIMOPw...213 NLMNIMXNw...213 NLMNIMYRw...213 NLMNINOKw... 213 NLMNINZDw...214 NLMNIPLNw...214 NLMNIRUBw... 214 NLMNISEKw...214 NLMNISGDw... 214 NLMNITHBw...214 NLMNITRYw...214 NLMNITWDw...214 NLMNIUSDw... 214 NLMNIZARw...214 NLMNLAEDw...214 NLMNLAUDw... 214 NLMNLBGNw... 214 NLMNLBRLw...214 NLMNLCADw... 214 NLMNLCHFw...214 NLMNLCNYw... 214 NLMNLCZKw...214
NLMNLDKKw...215 NLMNLEGPw... 215 NLMNLEURw... 215 NLMNLGBPw... 215 NLMNLHKDw... 215 NLMNLHRKw... 215 NLMNLHUFw...215 NLMNLIDRw...215 NLMNLILSw...215 NLMNLINRw...215 NLMNLJPYw... 215 NLMNLKRWw...215 NLMNLLTLw... 215 NLMNLLVLw...215 NLMNLMOPw...215 NLMNLMXNw...215 NLMNLMYRw...215 NLMNLNOKw... 215 NLMNLNZDw...216 NLMNLPLNw...216 NLMNLRUBw... 216 NLMNLSEKw...216 NLMNLSGDw... 216 NLMNLTHBw... 216 NLMNLTRYw... 216 NLMNLTWDw... 216 NLMNLUSDw... 216 NLMNLZARw...216 NLMNYw...216 NLMNYIw...216 NLNUMw... 216 NLNUMIw... 216 NLPCTw... 216 NLPCTIw... 216 NLTIMEw... 216 PDw.d... 216 PDJULGw...217 PDJULIw...217 PDTIMEw...217 PERCENTw...217 PIBw.d... 217 PIBRw.d...217 PKw.d... 217 RBw.d... 217 RMFDURw...217
S370FFw.d... 217 S370FIBw.d... 217 S370FIBUw.d...217 S370FPDw.d...217 S370FPDUw.d...217 S370FPIBw.d...217 S370FRBw.d...217 S370FZDw.d...217 S370FZDBw.d... 218 S370FZDLw.d...218 S370FZDSw.d... 218 S370FZDTw.d...218 S370FZDUw.d... 218 SMFSTAMPw.d... 218 TIMEw...218 TODSTAMPw... 218 TRAILSGNw.d... 218 TUw... 218 YENw...218 YMDDTTMw... 218 YYMMDDw... 218 YYMMNw...218 YYQw...218 ZDw.d... 218 ZDBw.d...218 Library Engines...219 CVP... 219 SASDASD... 219 SASV6...219 SASV7...219 SASV8...219 SASV9...219 SAS7BDAT... 219 SD2...220 SASSEQ...220 V8SEQ...220 V9SEQ...220 WPDSEQ...220 WPD... 220 WPD (z/OS)... 220 WPD1... 222 WPDV2...222 WPDV2 (z/OS)...222 XML... 223 XPORT... 225 Macro Processor Functions...225
%BQUOTE... 225
%CMPRES...225
%DATATYP...225
%DS2CSV...225
%EVAL... 226
%INDEX... 227
%LEFT...227
%LENGTH...227
%LOWCASE... 227
%NRBQUOTE...227
%NRQUOTE... 227
%NRSTR...227
%QCMPRES... 227
%QLEFT...228
%QLOWCASE...228
%QSCAN...228
%QSUBSTR...228
%QSYSFUNC... 228
%QTRIM...228
%QUOTE...228
%QUPCASE...229
%SCAN... 229
%STR... 229
%SUBSTR...229
%SUPERQ... 229
%SYMEXIST... 229
%SYMGLOBL...229
%SYMLOCAL...230
%SYSEVALF... 230
%SYSFUNC... 230
%SYSGET...230
%SYSPROD...230
%SYSRC...230
%TRIM...230
%UNQUOTE... 231
%UPCASE...231
%VERIFY... 231 Macro Processor Statements... 231
%ABORT... 231
%* comment...231
%COPY... 231
%DO...232
%DO, Iterative...232
%DO %UNTIL...232
%DO %WHILE...232
%EXECUTE... 232
%GLOBAL...233
%GOTO...233
%IF-%THEN/%ELSE...233
%INCLUDE...233
%label...233
%LET...233
%LOCAL...233
%MACRO...234
%MEND...234
%PUT... 234
%RETURN... 234
%SYSCALL... 235
%SYMDEL...235
%SYSEXEC... 235 Automatic Macro Variables...236 SYSADDRBITS... 236 SYSCHARWIDTH... 236 SYSCC... 236 SYSDATE... 236 SYSDATE9... 236 SYSDAY... 236 SYSDSN...236 SYSENDIAN...236 SYSENV...236 SYSERR...236 SYSERRORTEXT... 236 SYSFILRC...236 SYSENDIAN...236 SYSINDEX... 236 SYSINFO...236 SYSJOBID...236 SYSLAST... 236 SYSLIBRC...236 SYSMACRONAME...236 SYSMAXLONG... 236 SYSMENV...236 SYSPARM... 236 SYSPBUFF...236 SYSPROCESSID... 236 SYSPROCESSNAME... 236 SYSPROCNAME...236 SYSRC... 236 SYSSCP...237 SYSSCPL...237 SYSSITE... 237
SYSMAXLONG... 237 SYSSIZEOFPTR... 237 SYSSIZEOFUNICODE...237 SYSUID... 237 SYSUSERID...237 SYSVER...237 SYSVLONG...237 SYS99ERR...237 SYS99INF...237 SYS99MSG... 237 SYS99R15...237 Procedures...237 ACCESS Procedure...237 APPEND Procedure...240 APPSRV Procedure... 240 CATALOG Procedure...245 CDISC Procedure... 248 CHART Procedure... 252 CIMPORT Procedure... 256 COMPARE Procedure...258 CONTENTS Procedure...261 COPY Procedure... 262 CORR Procedure...264 CPORT Procedure...266 DATASETS Procedure... 268 DB2EXT Procedure...277 DBLOAD Procedure...277 DELETE Procedure...280 EXPORT Procedure...280 FMTLIB Procedure...283 FORMAT Procedure...288 FORMS Procedure...293 FREQ Procedure...294 IMPORT Procedure...302 JAVAINFO Procedure... 307 MEANS Procedure...307 OPTIONS Procedure... 314 OPTLOAD Procedure... 314 OPTSAVE Procedure...315 PDS Procedure... 315 PDSCOPY Procedure...316 PLOT Procedure... 317 PRINT Procedure...319 PRINTTO Procedure...322 PWENCODE Procedure... 322
RANK Procedure...326 RELEASE Procedure...327 REPORT Procedure...328 SOAP Procedure...336 SORT Procedure...337 SOURCE Procedure... 340 SQL Procedure... 342 STANDARD Procedure... 359 SUMMARY Procedure... 361 TABULATE Procedure... 368 TEMPLATE Procedure...371 TRANSPOSE Procedure... 387 TRANTAB Procedure... 389 UNIVARIATE Procedure... 390 System Options...395 _LAST_...395 AUTOEXEC...396 BLKSIZE...396 BYERR... 396 BYLINE...396 CAPS...396 CARDIMAGE...396 CENTER...396 CHARCODE...397 COMPRESS...397 CPUCOUNT... 397 DATASTMTCHK... 397 DATE... 397 DB2IN...397 DB2READBUFF... 398 DB2SSID... 398 DETAILS...398 DFLANG...398 DKRICOND... 398 DKROCOND...398 DLDSNTYPE...399 DLEXCPCOUNT... 399 DSNFERR... 399 DTRESET...399 DYNALLOC... 399 ECHO... 399 ECHOAUTO... 399 EMAILAUTHPROTOCOL...400 EMAILHOST...400 EMAILID... 400 EMAILPORT...400
EMAILPW...400 EMAILSYS...400 ENCODING... 400 ENGINE...400 ERRORABEND... 401 ERRORS... 401 FILEBLKSIZE(device-type)... 401 FILEMSGS... 401 FILESPPRI... 401 FILESPSEC...401 FILESTAT... 402 FILESYSOUT... 402 FILESYSTEM... 402 FILEUNIT...402 FILSZ...402 FIRSTOBS...403 FMTERR...403 FORMCHAR...403 FORMDLIM... 403 FULLSTATS...403 FULLSTIMER... 403 IMPLMAC... 404 INITSTMT...404 INVALIDDATA...404 ISPCAPS...404 ISPCHARF... 404 ISPCSR... 404 ISPEXECV...404 ISPMISS...405 ISPMSG...405 ISPNOTES... 405 ISPNZTRC...405 ISPPT... 405 ISPTRACE...405 ISPVDEFA...405 ISPDLT... 406 ISPVDTRC... 406 ISPVIMSG... 406 ISPVRMSG...406 ISPVTMSG...406 ISPVTNAM... 406 ISPVTPNL... 406 ISPVTRAP...407 ISPVTVARS...407 JREOPTIONS...407
LINESIZE...407 LISTINGFILERECFM... 408 LOCALE... 408 LOG...408 LOGPARM...408 MACRO... 408 MACROGEN... 408 MAUTOLOCDISPLAY... 409 MAUTOSOURCE... 409 MCOMPILE... 409 MCOMPILENOTE... 409 MEMRPT...409 MEMSIZE... 409 MERGENOBY... 410 MERROR...410 MISSING... 410 MLOGIC... 410 MLOGICNEST...410 MPRINT...410 MPRINTNEST... 410 MRECALL...411 MSGLEVEL... 411 MSTORED...411 MTRACE... 411 MVARSIZE... 411 NEWS...411 NLSCOMPATMODE...411 NOTES... 412 NUMBER...412 OBS... 412 ODSDEST... 412 OLDMAC... 412 OVP... 412 PAGENO... 413 PAGESIZE...413 PARM... 413 PRINT...413 QUOTELENMAX...413 REPLACE...413 S... 414 S2... 414 S99NOMIG...414 SASAUTOS... 414 SASHELP...414 SASINITIALFOLDER...414 SASMSTORE... 415
SASTRACE... 415 SASTRACELOC...415 SASUSER... 415 SEQ... 415 SEQENGINE... 416 SEQNUMFEACH...416 SERROR... 416 SORTCUTP...416 SORTDEV... 416 SORTDUP... 416 SORTEQOP... 417 SORTEQUALS... 417 SORTLIST... 417 SORTMSG... 417 SORTNAME... 417 SORTOPTS...417 SORTPARM... 417 SORTPGM... 418 SORTSEQ... 418 SORTSIZE...418 SORTSUMF... 418 SORTVALIDATE...418 SOURCE... 419 SOURCE2... 419 STDIO...419 STIMEFMT... 419 STIMER...419 SUMSIZE...420 SYMBOLGEN...420 SYSFILRC...420 SYSIN...420 SYSLIBRC...420 SYSPARM... 420 SYSPREF...420 TAPECLOSE... 421 TERMSTMT...421 DETAILS...421 TRANTAB... 421 USER...421 VARLENCHK...421 VERBOSE... 422 VNFERR...422 VSAMLOAD...422 VSAMREAD... 422 VSAMUPDATE... 422
WORKINIT...422 WORKTERM... 423 WPDHUGE...423 WPSTRACE... 423 XCMD...424 XMIN...424 XSYNC... 424 XWAIT... 424 YEARCUTOFF... 424
WPS Graphing... 425
Global Statements... 425 AXIS... 425 FOOTNOTE...427 GOPTIONS...429 LEGEND...435 PATTERN... 437 SYMBOL...437 Graphing Procedures...439 GCHART Procedure... 439 GOPTIONS Procedure...450 GPLOT Procedure... 451 GREPLAY Procedure...455
WPS Statistics... 458
Statistics Procedures... 458 ANOVA Procedure... 458 CLUSTER Procedure...461 CORRESP Procedure...463 DISCRIM Procedure... 467 DISTANCE Procedure...471 FACTOR Procedure... 476 FASTCLUS Procedure...479 GLM Procedure...483 GLMMOD Procedure... 486 KDE Procedure... 487 LOGISTIC Procedure...489 PRINCOMP Procedure... 497 REG Procedure...499 SCORE Procedure...505 STDIZE Procedure...506 STEPDISC Procedure...509 SURVEYSELECT Procedure...511 TREE Procedure...514 TTEST Procedure... 518 VARCLUS Procedure...521
WPS Timeseries...524
Timeseries Procedures... 524 ARIMA Procedure... 524 EXPAND Procedure... 529 FORECAST Procedure...534 X12 Procedure... 537
WPS Communicate... 549
Global Statements... 549 ENDRSUBMIT...549 RSUBMIT... 549 SIGNOFF...551 SIGNON... 551 Macro Processor Statements... 553
%SYSLPUT...553
%SYSRPUT... 553 Procedures...553 DOWNLOAD Procedure... 553 UPLOAD Procedure...556 System Options...558 AUTOSIGNON... 558 COMAMID... 558 CONNECTPERSIST... 558 CONNECTREMOTE... 558 DMR... 559 SASSCRIPT... 559 SASCMD... 559
WPS Engine for Actian Matrix... 560
Library Engines...560 ACTIANMATRIX... 560
WPS Engine for DB Files... 564
Library Engines...564 SPSS...564 SPSSDIR...564 Procedures...564 DBF Procedure... 564
WPS Engine for DB2...565
Library Engines...565 DB2...565
Procedures...571 DB2EXT Procedure...571
WPS Engine for Greenplum...573
Library Engines...573 GREENPLUM...573
WPS Engine for Informix...577
Library Engines...577 INFORMIX...577
WPS Engine for Kognitio... 581
Library Engines...581 KOGNITIO...581
WPS Engine for MySQL... 585
Library Engines...585 MYSQL...585
WPS Engine for NETEZZA... 589
Library Engines...589 NETEZZA... 589
WPS Engine for ODBC... 593
Library Engines...593 ODBC... 593
WPS Engine for OLEDB... 597
Library Engines...597 OLEDB... 597
WPS Engine for Oracle...601
Library Engines...601 ORACLE...601
WPS Engine for PostgreSQL... 605
Library Engines...605 POSTGRESQL...605
WPS Engine for SAND...609
Library Engines...609 SAND...609
WPS Engine for SQL Server... 613
Library Engines...613 SQLSERVR... 613
WPS Engine for Sybase... 617
Library Engines...617 SYBASE... 617
WPS Engine for Teradata... 621
Library Engines...621 TERADATA...621
WPS Engine for Vertica... 625
Library Engines...625 VERTICA... 625
Appendix... 629
Identifying Access And View Descriptors...629 Identifying Data Sets... 629 Expressions...630 External Files... 634 LOCALE Values... 634 ODS Selection Lists...636 Variable Lists...637 Identifying Views... 637
Legal Notices... 638
How to Read EBNF Notation and Syntax
Diagrams
EBNF (Extended Backus-Naur Form) and syntax diagrams are notations that help to explain the syntax of programming languages. This section describes how to read them.
EBNF is a textual notation, and syntax diagrams are a graphical notation - they form part of the reference information that accompanies significant language structures such as procedures, statements and so on. In each case, the textual EBNF representation is equivalent to the graphical syntax diagram representation - they are simply two ways of describing the same syntactical concepts.
The description of each language concept commences with its EBNF representation, and is followed by its syntax diagram.
Entering text
Text that should be entered exactly as displayed is shown in a typewriter font, with letters in upper case, in both EBNF and syntax diagram formats:
OUTPUT;
OUTPUT ;
Generally the case is not significant, but it is the convention in this reference to use upper case for keywords.
Placeholder items
Placeholders that should be substituted with text relevant to the program are shown in italic font, with letters in lower case, as shown by the following example:
OUTPUT data-set-name ;
OUTPUT data-set-name ;
In the above example, the keyword OUTPUT should be entered literally, but data-set-name should be replaced by something appropriate to the program, in this case the name of a data set to add an observation to.
Optionality
When items are optional they appear on a branch below the main line, as shown by the following example: OUTPUT [ data-set-name ] ;
OUTPUT
data-set-name
;
Note that in EBNF, optionality is denoted by square brackets: [ ], while in the syntax diagram it is represented by an alternative unimpeded path through the diagram.
In the above example the keyword OUTPUT should be entered literally, and optionally a data set name can be specified.
Repetition
Items that can be repeated are shown with a return loop, that optionally specifies the separator that should be included between multiple instances, as shown by the following example:
OUTPUT { data-set-name } ;
OUTPUT data-set-name ;
Above, the keyword OUTPUT should be entered literally, and it should be followed by one or more repetitions of data-set-name - in this case, no separator other than a space has been asked for. In EBNF, such a repetition is denoted by curly braces: { }.
If a separator is required, it is shown on the syntax diagram's return loop. Note that in EBNF, the repetition separator - if present - is enclosed between angular brackets and printed in bold type face: <,>. The brackets demarcate the separator boundaries accurately.
function-name ( { <,> argument } )
function-name (
,
argument )
In the above example, argument can be specified one or more times, but a comma "," must be used to separate multiple arguments.
Choices
Where one of a number of choices must be selected, they are depicted like so: GETNAMES [ YES | NO ] ;
GETNAMES YES
NO
;
In EBNF, the choice is represented by a logical OR symbol "|" between each option.
In the above example, the keyword GETNAMES should be entered literally, and then either the keyword YES or the keyword NO should be entered literally.
Fragments
Where the syntax is too complicated to fit in one diagram it is broken up into fragments, as shown by
PROCPRINT { option }
PROC PRINT option
option
[ DATA= data-set-name | LABEL ]
DATA = data-set-name LABEL
Above, the whole syntax is split into separate syntax diagram and EBNF fragments. The first indicates that PROC PRINT should be followed by one or more instances of an option, each of which must adhere to the syntax given in the second diagram.
WPS Core
Components
HASH Component
HASH
HASH [ ( { <,> argument-list } ) ] HASH
(
,
argument-list )
argument-list
[ DATASET:" dataset-name " [ ( { dataset-option } ) ] | DUPLICATE: [ "replace" | "r" | "error" |
"e" ] | HASHEXP: integer | MULTIDATA: [ "yes" | "y" | "no" | "n" ] | SUMINC:" variable " | ORDERED : [ "yes" | "y" | "no" | "n" ] ]
DATASET : "dataset-name "
( dataset-option )
DUPLICATE : "replace"
"r"
"error"
"e" HASHEXP :integer MULTIDATA : "yes"
"y"
"no"
"n" SUMINC : "variable " ORDERED : "yes"
"y"
"no"
"n"
ADD
ADD( { <,> KEY: key-value } { <,> DATA: value } );
, ,
CHECK
CHECK( { <,> KEY: key-value } );
CHECK (
,
KEY :key-value ) ;
CLEAR CLEAR();
CLEAR ( ) ;
DECLARE
DECLARE component-type component-nameReference [ ( { <,> component-argument : value } ) ] ; DECLARE component-type component-nameReference
(
,
component-argument :value )
;
DEFINEDATA
DEFINEDATA( [ ALL:"YES" | { <,> variable-name } ] ); DEFINEDATA ( ALL : "YES"
, variable-name
) ;
DEFINEDONE
DEFINEDONE(MEMRC:" char-value ");
DEFINEDONE ( MEMRC : "char-value " ) ;
DEFINEKEY
DEFINEKEY( [ ALL:"YES" | { <,> " variable-name " } ] ); DEFINEKEY ( ALL : "YES"
,
"variable-name "
) ;
DELETE DELETE();
DELETE ( ) ;
EQUALS
EQUALS(HASH:" other-hash-name "RESULT:" variable-name ");
EQUALS ( HASH : "other-hash-name " RESULT : "variable-name" ) ;
FIND
FIND( { <,> KEY:" value " } );
FIND (
,
KEY : "value " ) ;
FIND_NEXT FIND_NEXT();
FIND_NEXT ( ) ;
FIND_PREV FIND_PREV();
FIND_PREV ( ) ;
HAS_NEXT
HAS_NEXT(RESULT: variable );
HAS_NEXT ( RESULT :variable ) ;
HAS_PREV
HAS_PREV(RESULT: variable );
HAS_PREV ( RESULT :variable ) ;
ITEM_SIZE ITEM_SIZE;
ITEM_SIZE ;
NUM_ITEMS NUM_ITEMS;
NUM_ITEMS ;
OUTPUT
OUTPUT( { <,> DATASET: dataset-name } );
OUTPUT (
,
DATASET :dataset-name ) ;
REF
REF( { <,> KEY: key-value } { <,> DATA: value } );
REF (
, KEY :key-value
,
DATA :value ) ;
REMOVE
REMOVE( { <,> KEY:" key-value " } );
REMOVE (
,
KEY : "key-value " ) ;
REMOVEDUP
REMOVEDUP( { <,> KEY:" key-value " } );
REMOVEDUP (
,
KEY : "key-value " ) ;
REPLACE
REPLACE( { <,> KEY:" key-value " } { <,> DATA: value } );
REPLACE (
,
KEY : "key-value "
,
DATA :value ) ;
REPLACEDUP
REPLACEDUP( { <,> DATA: value } );
REPLACEDUP (
,
DATA :value ) ;
SUM
SUM(SUM: variable ); SUM ( SUM :variable ) ;
SUMDUP
SUMDUP(SUM: variable ); SUMDUP ( SUM :variable ) ;
HITER Component
HITER
HITER [ ( { <,> argument-list } ) ] HITER
(
,
argument-list )
argument-list
" hash-object-name "
"hash-object-name "
FIRST FIRST();
FIRST ( ) ;
NEXT NEXT();
NEXT ( ) ;
SUM
SUM(SUM: variable );
SUM ( SUM :variable ) ;
Unsupported Statements
The following statements are not yet supported
• LAST
• PREV
• SETCUR
JAVAOBJ Component
JAVAOBJ
[ BYTE | CHAR | SHORT | INT | LONG | FLOAT | DOUBLE | STRING ]
BYTE CHAR SHORT
INT LONG FLOAT DOUBLE STRING
JAVAOBJ [ ( class-identifier [ { , constructor-argument } ] ) ] JAVAOBJ
( class-identifier
, constructor-argument
)
class-identifier
[ { package-name / } ] class-name [ { $ nested-class-name } ]
package-name /
class-name
$ nested-class-name
CALLSTATICtypeMETHOD
CALLSTATICtypeMETHOD( method-name [ { <,> method-argument } ] , return-variable ); CALLSTATICtypeMETHOD ( method-name
, method-argument
,
return-variable ) ;
CALLtypeMETHOD
CALLtypeMETHOD( method-name [ { <,> method-argument } ] , return-variable ); CALLtypeMETHOD ( method-name
, method-argument
, return-variable )
;
CALLSTATICVOIDMETHOD
CALLSTATICVOIDMETHOD( method-name [ { <,> method-argument } ] ); CALLSTATICVOIDMETHOD ( method-name
, method-argument
) ;
CALLVOIDMETHOD
CALLVOIDMETHOD( method-name [ { <,> method-argument } ] ); CALLVOIDMETHOD ( method-name
, method-argument
) ;
EXCEPTIONCHECK
EXCEPTIONCHECK( numeric-variable );
EXCEPTIONCHECK ( numeric-variable ) ;
EXCEPTIONCLEAR EXCEPTIONCLEAR();
EXCEPTIONCLEAR ( ) ;
EXCEPTIONDESCRIBE
EXCEPTIONDESCRIBE( boolean-value );
EXCEPTIONDESCRIBE ( boolean-value ) ;
FLUSHJAVAOUTPUT FLUSHJAVAOUTPUT();
FLUSHJAVAOUTPUT ( ) ;
GETSTATICtypeFIELD
GETSTATICtypeFIELD( field-name , return-variable );
GETSTATICtypeFIELD ( field-name , return-variable ) ;
GETtypeFIELD
GETtypeFIELD( field-name , return-variable );
GETtypeFIELD ( field-name , return-variable ) ;
SETSTATICtypeFIELD
SETSTATICtypeFIELD( field-name , value );
SETSTATICtypeFIELD ( field-name , value ) ;
SETtypeFIELD
SETtypeFIELD( field-name , value );
SETtypeFIELD ( field-name , value ) ;
DATA Step Functions and CALL Routines
ABS
ABS( argument )
ABS ( argument )
ADDR
ADDR( variable )
ADDR ( variable )
ADDRLONG
ADDRLONG( variable )
ADDRLONG ( variable )
ADDRLONGX
ADDRLONGX(" variable-name ")
ADDRLONGX ( "variable-name " )
ADDRX
ADDRX(" variable-name ")
ADDRX ( "variable-name" )
AIRY
AIRY( z )
AIRY ( z )
ANYALNUM
ANYALNUM( string [ , start ] ) ANYALNUM ( string
, start
)
ANYALPHA
ANYALPHA( string [ , start ] ) ANYALPHA ( string
, start
)
ANYCNTRL
ANYCNTRL( string [ , start ] ) ANYCNTRL ( string
, start
)
ANYDIGIT
ANYDIGIT( string [ , start ] ) ANYDIGIT ( string
, start
)
ANYFIRST
ANYFIRST( string [ , start ] ) ANYFIRST ( string
, start
)
ANYGRAPH
ANYGRAPH( string [ , start ] ) ANYGRAPH ( string
, start
)
ANYLOWER
ANYLOWER( string [ , start ] ) ANYLOWER ( string
, start
)
ANYNAME
ANYNAME( string [ , start ] ) ANYNAME ( string
, start
)
ANYPRINT
ANYPRINT( string [ , start ] ) ANYPRINT ( string
, start
)
ANYPUNCT
ANYPUNCT( string [ , start ] ) ANYPUNCT ( string
, start
)
ANYSPACE
ANYSPACE( string [ , start ] ) ANYSPACE ( string
, start
)
ANYUPPER
ANYUPPER( string [ , start ] ) ANYUPPER ( string
, start
)
ANYXDIGIT
ANYXDIGIT( string [ , start ] ) ANYXDIGIT ( string
, start
)
APPSRVGETC
APPSRVGETC( option-name )
APPSRVGETC ( option-name )
APPSRVGETN
APPSRVGETN( option-name )
APPSRVGETN ( option-name )
APPSRVSET
APPSRVSET( name , value )
APPSRVSET ( name , value )
APPSRV_AUTHCLS
APPSRV_AUTHCLS( type )
APPSRV_AUTHCLS ( type )
APPSRV_AUTHDS
APPSRV_AUTHDS( dataset )
APPSRV_AUTHDS ( dataset )
APPSRV_AUTHLIB
APPSRV_AUTHLIB( [ libname [ , memname [ , memtype [ , objname [ , objtype ] ] ] ] ] )
APPSRV_AUTHLIB (
libname
, memname
, memtype
, objname
, objtype
)
APPSRV_HEADER
APPSRV_HEADER( name , value )
APPSRV_HEADER ( name , value )
APPSRV_SESSION
APPSRV_SESSION( [ "delete" | "create" [ timeout ] ] ) APPSRV_SESSION ( "delete"
"create"
timeout
)
APPSRV_SET
APPSRV_SET( name , value )
APPSRV_SET ( name , value )
APPSRV_UNSAFE
APPSRV_UNSAFE( paramname )
APPSRV_UNSAFE ( paramname )
ARCOS
ARCOS( argument )
ARCOS ( argument )
ARCOSH
ARCOSH( argument )
ARCOSH ( argument )
ARSIN
ARSIN( argument )
ARSIN ( argument )
ARSINH
ARSINH( argument )
ARSINH ( argument )
ARTANH
ARTANH( argument )
ARTANH ( argument )
ARTAN
ARTAN( argument )
ARTAN ( argument )
ATAN2
ATAN2( argument-1 , argument-2 )
ATAN2 ( argument-1 , argument-2 )
ATTRC
ATTRC( data-set-id , character-attribute )
ATTRC ( data-set-id , character-attribute )
character-attribute
[ "ENGINE" | "LABEL" | "LIB" | "MEM" | "MODE" | "MTYPE" | "SORTEDBY" | "SORTLVL" ]
"ENGINE"
"LABEL"
"LIB"
"MEM"
"MODE"
"MTYPE"
"SORTEDBY"
"SORTLVL"
Unsupported Options
The following options are not yet supported:
• CHARSET
• ENCRYPT
• SORTSEQ
• TYPE
ATTRN
ATTRN( data-set-id , numeric-attribute )
ATTRN ( data-set-id , numeric-attribute )
numeric-attribute
[ "ANOBS" | "ANY" | "ARAND" | "ICONST" | "INDEX" | "ISINDEX" | "ISSUBSET" | "NOBS" | "NVARS"
| "WHSTMT" ]
"ANOBS"
"ANY"
"ARAND"
"ICONST"
"INDEX"
"ISINDEX"
"ISSUBSET"
"NOBS"
"NVARS"
"WHSTMT"
Unsupported Options
The following options are not yet supported:
• ALTERPW
• ARWU
• AUDIT
• AUDIT_DATA
• AUDIT_BEFORE
• AUDIT_ERROR
• CRDTE
• LRECL
• LRID
• MAXGEN
• MAXRC
• MODTE
• NDEL
• NEXTGEN
• NLOBS
• NLOBSF
• PW
• RADIX
• READPW
• TAPE
• WRITEPW
BAND
BAND( argument-1 , argument-2 )
BAND ( argument-1 , argument-2 )
BETA
BETA( argument-1 , argument-2 )
BETA ( argument-1 , argument-2 )
BETAINV
BETAINV( percentile , argument-1 , argument-2 )
BETAINV ( percentile , argument-1 , argument-2 )
BLACKCLPRC
BLACKCLPRC( exercise-price , time , future-price , rate , volatility )
BLACKCLPRC ( exercise-price , time , future-price , rate , volatility )
BLACKPTPRC
BLACKPTPRC( exercise-price , time , future-price , rate , volatility )
BLACKPTPRC ( exercise-price , time , future-price , rate , volatility )
BLKSHCLPRC
BLKSHCLPRC( exercise-price , time , share-price , rate , volatility )
BLKSHCLPRC ( exercise-price , time , share-price , rate , volatility )
BLKSHPTPRC
BLKSHPTPRC( exercise-price , time , share-price , rate , volatility )
BLKSHPTPRC ( exercise-price , time , share-price , rate , volatility )
BLSHIFT
BLSHIFT( argument-1 , argument-2 )
BLSHIFT ( argument-1 , argument-2 )
BNOT
BNOT( argument-1 )
BNOT ( argument-1 )