Home of the SAS editor
SAS editing tool
Support for your SAS toolkit
Tools for SAS programming
SAS editor for the new millenium SAS tool, toolkit or IDE buy it today

SAS Template and Keyword List

Templates are a Multi-Edit is similar to the MASK function for ISPF and the abbreviation list for VI. It allows you to type a few characters (keyword) to generate syntactically correct code with "fill in the blank" areas. The templates contain text surrounded in the "back leaning" quote mark. These represent code pieces that must be entered to suit the specific requirements for this location. They are called field strings. You can use Cntl-i to hop to the next field string beyond the cursor. This selects the whole field string so that typing overwrites it all. Find out more about how to use templates in the online manual.

Template Name Invocation Keyword Description
Jump To: Help Smart Language Global Comment Proc Data Functions
Help templates: In addition to code these templates list options and contain comments to describe the use of the code and options. Find out more in the manual.
qshowcode?debugExpand all source and macros
qsystem_options?system 
qdataset_options?datasetAll the options for a data step
qlibname?libname 
qlabel?label 
qinfile?infile 
qfilename?filename 
qfile?file 
qby?by 
qintnx?intnxDate time interval increment
qintck?intckDate time interval difference
qfopen?fopenFile open
qattrc?attrc 
qattrn?attrn 
qcdf?cdf 
qarray?array 
Smart templates: These templates display dialog boxes allowing you to pick (with check boxes) all the options and sub statements and their options you want included in the proc step. Find out how these work in the manual.
Proc_Comparecompare* 
Proc_Datasetsdatasets* 
Proc_meansmeans* 
Proc_Summsummary* 
Sql_Querysqlq* 
Proc_Sqlsql* 
Proc_Tabulatetabulate* 
Jump To: Help Smart Language Global Comment Proc Data Functions
Programming/Language constructs: These templates lay out all the variations of conditional and loop statements. See how they expand in the manual.
ifelsedoifed 
ifthendoiftd 
ifelseifelse 
ifthenifthen 
ififs 
dowhiledow 
dountildou 
dotobydotb 
dotodot 
dooverdoo 
selectwhenotherwiseselo 
selectwhensel 
whenwh 
Global statement templates: These templates create statements that apply to the whole program such as run options for debugging and libname assignments.
G_libname_clearlibnamec 
G_libnamelibname 
G_filename_clearfilenamec 
G_filenamefilename 
G_options_debugoptdExpand all source and macros
Debug and Comment templates: These templates create comment blocks or prolog comments, most would not be invoked by a keyword, but instead by a button or menu choice. Find out details about how to use debug and comment templates in the manual.
DbugPutAlldputaPlaces a put _ALL_ statement will other text that will idetify the line and allow it to work with the log viewing tools
ComEOLDate/*dOnly expands at the end of a line, adds the current time date stamp to the comment
ComEndOfLine/*Only expands at the end of a line, places your cursor inside the /* */ so you can type your text
ComBlock 1*cbkComment block with 1 * like
/*************/
/* some text */
/*************/
ComBlock 2*cbk2Two stars on sides like /** .... **/
ComBlock 3*cbk3Three stars on sides like /*** .... ***/
ComBlockLinecblPlaces comment block around selected lines
Maintainance_infomaintAdds a line with time-date and programmer name and change description to a prolog block in the maintenance area
PrologprologPlaces a comment block used to specify basic module information, gathered through prompts
Jump To: Help Smart Language Global Comment Proc Data Functions
Proc templates: These templates expand into popular proc steps. The names are fairly explanatory. Learn more about these in the manual.
Proc_univariatepunivariate 
Proc_transposeptranspose 
Proc_timeplotptimeplot 
Proc_tabulateptabulate 
Proc_summarypsummary 
Proc_standardpstandard 
Proc_spell_dicpspelld 
Proc_spellpspell 
Proc_sortpsort 
Proc_reportpreport 
Proc_rankprank 
Proc_printpprint 
Proc_plotpplot 
Proc_optionspoptions 
Proc_meanspmeans 
Proc_freqpfreq 
Proc_formatpformat 
Proc_datasetspdatasets 
Proc_cportpcport 
proc_corrpcorr 
Proc_copypcopy 
Proc_contentspcontents 
Proc_comparepcompare 
Proc_cimportpcimport 
Proc_chartpchart 
Proc_catalogpcatalog 
Proc_appendpappend 
Data statement templates: These templates expand into data statements. The names are fairly explanatory. Find out what these expand into in the manual.
DATABYdatabyData statement followed with a by statement
DATACARDdatacardData step with instream data
DATAMERGEdatamergeData step merging one or more datasets
Jump To: Help Smart Language Global Comment Proc Data Functions
Function templates: These templates expand into popular function calls. The names are fairly explanatory. Find out more in the manual.
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
FuncCasadef()Function Cascade is a template invoked, menu driven method to invoke a function template by picking it from a list. You will be presented with a popup menu. This menu presents a list of major groups of functions. As you make selections the last popup disappears and a new one appears in its place listing a subset of groups or actual function names. Learn how this works in the manual.
zipstatezipstate( 
zipnamelzipnamel( 
zipnamezipname( 
zipfipszipfips( 
yyqyyq( 
yearyear( 
weekdayweekday( 
wakeupwakeup( 
verifyverify( 
vartypevartype( 
varnumvarnum( 
varnamevarname( 
varlenvarlen( 
varlabelvarlabel( 
varinfmtvarinfmt( 
varfmtvarfmt( 
varvar( 
ussuss( 
upcaseupcase( 
uniformuniform( 
tsotso( 
trunctrunc( 
trimntrimn( 
trimtrim( 
trigammatrigamma( 
tranwrdtranwrd( 
translatetranslate( 
todaytoday( 
tnoncttnonct( 
tinvtinv( 
timeparttimepart( 
Jump To: Help Smart Language Global Comment Proc Data Functions
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
timetime( 
tanhtanh( 
tantan( 
systemsystem( 
sysrcsysrc( 
sysprodsysprod( 
sysmsgsysmsg( 
sysgetsysget( 
symgetsymget( 
sumsum( 
substrsubstr( 
stnamelstnamel( 
stnamestname( 
stfipsstfips( 
stderrstderr( 
stdstd( 
sqrtsqrt( 
spedisspedis( 
soundexsoundex( 
sleepsleep( 
skewnessskewnexx( 
sinhsinh( 
sinsin( 
signsign( 
secondsecond( 
sdfsdf( 
scanscan( 
savingsaving( 
roundround( 
rightright( 
rewindrewind( 
reversereverse( 
resolveresolve( 
repeatrepeat( 
ranuniranuni( 
rantrirantri( 
Jump To: Help Smart Language Global Comment Proc Data Functions
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
rantblrantbl( 
ranpoiranpoi( 
rannorrannor( 
rankrank( 
rangerange( 
rangamrangam( 
ranexpranexp( 
rancaurancau( 
ranbinranbin( 
quotequote( 
qtrqtr( 
putnputn( 
putcputc( 
putput( 
probtprobt( 
probnormprobnorm( 
probnegbprobnegb( 
probmcprobmc( 
probitprobit( 
probhyprprobhypr( 
probgamprobgam( 
probfprobf( 
probchiprobchi( 
probbnmlprobbnrm( 
probbetaprobbeta( 
poissonpoisson( 
pointpoint( 
pdfpdf( 
pathnamepathname( 
ordinalordinal( 
openopen( 
notenote( 
normalnormal( 
nmissnmiss( 
netpvnetpv( 
nn( 
mortmort( 
mopenmopen( 
monthmonth( 
modmod( 
minuteminute( 
minmin( 
meanmean( 
Jump To: Help Smart Language Global Comment Proc Data Functions
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
mdymdy( 
maxmax( 
lowcaselowcase( 
logsdflogsdf( 
logpdflogpdf( 
loglog 
loglog( 
libreflibref( 
libnamelibname( 
lgammalgamma( 
lengthlength( 
leftleft( 
lboundlbound( 
laglag( 
kurtosiskurtosis( 
jbesseljbessel( 
irrirr( 
intrrintrr( 
intnxintnx( 
intckintck( 
intint( 
inputninputn( 
inputcinputc( 
inputinput( 
indexwindexw( 
indexcindexc( 
indexindex( 
ibesselibessel( 
hourhour( 
hmshms( 
hboundhbound( 
getvarngetvarn( 
getvarcgetvarc( 
getoptiongetoption( 
Jump To: Help Smart Language Global Comment Proc Data Functions
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
gammagamma( 
gaminvgaminv( 
fwritefwrite( 
fuzzfuzz( 
fsepfsep( 
frlenfrlen( 
frewindfrewind( 
freadfread( 
fputfput( 
fposfpos( 
fpointfpoint( 
foptnumfoptnum( 
foptnamefoptname( 
fopenfopen( 
fnotefnote( 
fnonctfnonct( 
floorfloor( 
fipstatefipstate( 
fipnamelfipnamel( 
fipnamefipname( 
finvfinv( 
finfofinfo( 
filereffileref( 
filenamefilename( 
fileexistfileexist( 
fgetfget( 
fexistfexist( 
fetchobsfetchobs( 
fetchfetch( 
fdeletefdelete( 
fcolfcol( 
fclosefclose( 
fappendfappend( 
expexp( 
existexist( 
erfcerfc( 
erferf( 
dsnamedsname( 
dropnotedropnote( 
dreaddread( 
Jump To: Help Smart Language Global Comment Proc Data Functions
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
doptnumdoptnum( 
doptnamedoptname( 
dopendopen( 
dnumdnum( 
dinfodinfo( 
dimdim( 
digammadigamma( 
difdif( 
dhmsdhms( 
dequotedequote( 
deptabdeptab( 
depsyddepsyd( 
depsldepsl( 
depdbsldepdbsl( 
depdbdepdb( 
dclosedclose( 
dayday( 
datetimedatetime( 
datepartdatepart( 
datedate( 
dairydairy( 
dacctabdacctab( 
daccsyddaccsyd( 
daccsldaccsl( 
daccdbsldaccdbsl( 
daccdbdaccdb( 
cvcv( 
curobscurobs( 
csscss( 
coshcosh( 
coscos( 
compresscompress( 
compoundcompound( 
compblcompbl( 
collatecollate( 
cnonctcnonct( 
Jump To: Help Smart Language Global Comment Proc Data Functions
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
closeclose( 
cinvcinv( 
cexistcexist( 
ceilceil( 
cdfcdf( 
bytebyte( 
bxorbxor( 
brshiftbrshift( 
borbor( 
bnotbnot( 
blshiftblshift( 
betainvbetainv( 
bandband( 
attrnattrn( 
attrcattrc( 
atanatan( 
arsinarsin( 
arcosarcos( 
airyairy( 
absabs( 
Jump To: Help Smart Language Global Comment Proc Data Functions
Jump To Functions: A-C D-E F-G H-I J-L M-N O-P Q-R S T U-Z
Find a page Fast


Home : About Us | Links | Site Map | News Releases | Contact Us
Support : Tips and Hints | Downloads and Patches | Manual | FAQs | Newsletters | Bug Reports | Suggestions
Products : Overview of Features | Features | Screen Shots | Free Trial | Purchase | Lite Version

EZRTools created by Martin Works, Inc.

50 Myrtle Street, Susquehanna, PA 18847 570-396-3121




Copyright © 2000-, Martin Works Inc., Text, graphics, and HTML code are protected by US and International Copyright Laws, and may not be copied, reprinted, published, translated, hosted, or otherwise distributed by any means without explicit permission. SAS® is a registered trademark of SAS Institute, Inc. in Cary, NC. Multi-Edit® is a trademark of Multi-Edit Software Inc. All other logos and trademarks in this site are property of their respective owners.