SAS函数汇总.docx

SAS函数汇总.docx

《SAS函数汇总.docx》由会员分享，可在线阅读，更多相关《SAS函数汇总.docx（61页珍藏版）》请在冰豆网上搜索。

SAS函数汇总

Category

FunctionsandCALLRoutines

Description

Arithmetic

DIVIDEFunction

ReturnstheresultofadivisionthathandlesspecialmissingvaluesforODSoutput.

Array

DIMFunction

Returnsthenumberofelementsinanarray.

HBOUNDFunction

Returnstheupperboundofanarray.

LBOUNDFunction

Returnsthelowerboundofanarray.

BitwiseLogicalOperations

BANDFunction

ReturnsthebitwiselogicalANDoftwoarguments.

BLSHIFTFunction

Returnsthebitwiselogicalleftshiftoftwoarguments.

BNOTFunction

ReturnsthebitwiselogicalNOTofanargument.

BORFunction

ReturnsthebitwiselogicalORoftwoarguments.

BRSHIFTFunction

Returnsthebitwiselogicalrightshiftoftwoarguments.

BXORFunction

ReturnsthebitwiselogicalEXCLUSIVEORoftwoarguments.

CharacterStringMatching

CALLPRXCHANGERoutine

Performsapattern-matchingreplacement.

CALLPRXDEBUGRoutine

EnablesPerlregularexpressionsinaDATAsteptosenddebuggingoutputtotheSASlog.

CALLPRXFREERoutine

FreesmemorythatwasallocatedforaPerlregularexpression.

CALLPRXNEXTRoutine

Returnsthepositionandlengthofasubstringthatmatchesapattern,anditeratesovermultiplematcheswithinonestring.

CALLPRXPOSNRoutine

Returnsthestartpositionandlengthforacapturebuffer.

CALLPRXSUBSTRRoutine

Returnsthepositionandlengthofasubstringthatmatchesapattern.

PRXCHANGEFunction

Performsapattern-matchingreplacement.

PRXMATCHFunction

Searchesforapatternmatchandreturnsthepositionatwhichthepatternisfound.

PRXPARENFunction

Returnsthelastbracketmatchforwhichthereisamatchinapattern.

PRXPARSEFunction

CompilesaPerlregularexpression（PRX）thatcanbeusedforpatternmatchingofacharactervalue.

PRXPOSNFunction

Returnsacharacterstringthatcontainsthevalueforacapturebuffer.

Character

ANYALNUMFunction

Searchesacharacterstringforanalphanumericcharacter,andreturnsthefirstpositionatwhichthecharacterisfound.

ANYALPHAFunction

Searchesacharacterstringforanalphabeticcharacter,andreturnsthefirstpositionatwhichthecharacterisfound.

ANYCNTRLFunction

Searchesacharacterstringforacontrolcharacter,andreturnsthefirstpositionatwhichthatcharacterisfound.

ANYDIGITFunction

Searchesacharacterstringforadigit,andreturnsthefirstpositionatwhichthedigitisfound.

ANYFIRSTFunction

SearchesacharacterstringforacharacterthatisvalidasthefirstcharacterinaSASvariablenameunderVALIDVARNAME=V7,andreturnsthefirstpositionatwhichthatcharacterisfound.

ANYGRAPHFunction

Searchesacharacterstringforagraphicalcharacter,andreturnsthefirstpositionatwhichthatcharacterisfound.

ANYLOWERFunction

Searchesacharacterstringforalowercaseletter,andreturnsthefirstpositionatwhichtheletterisfound.

ANYNAMEFunction

SearchesacharacterstringforacharacterthatisvalidinaSASvariablenameunderVALIDVARNAME=V7,andreturnsthefirstpositionatwhichthatcharacterisfound.

ANYPRINTFunction

Searchesacharacterstringforaprintablecharacter,andreturnsthefirstpositionatwhichthatcharacterisfound.

ANYPUNCTFunction

Searchesacharacterstringforapunctuationcharacter,andreturnsthefirstpositionatwhichthatcharacterisfound.

ANYSPACEFunction

Searchesacharacterstringforawhite-spacecharacter（blank,horizontalandverticaltab,carriagereturn,linefeed,andformfeed）,andreturnsthefirstpositionatwhichthatcharacterisfound.

ANYUPPERFunction

Searchesacharacterstringforanuppercaseletter,andreturnsthefirstpositionatwhichtheletterisfound.

ANYXDIGITFunction

Searchesacharacterstringforahexadecimalcharacterthatrepresentsadigit,andreturnsthefirstpositionatwhichthatcharacterisfound.

BYTEFunction

ReturnsonecharacterintheASCIIortheEBCDICcollatingsequence.

CALLCATSRoutine

Removesleadingandtrailingblanks,andreturnsaconcatenatedcharacterstring.

CALLCATTRoutine

Removestrailingblanks,andreturnsaconcatenatedcharacterstring.

CALLCATXRoutine

Removesleadingandtrailingblanks,insertsdelimiters,andreturnsaconcatenatedcharacterstring.

CALLCOMPCOSTRoutine

SetsthecostsofoperationsforlaterusebytheCOMPGEDfunction

CALLMISSINGRoutine

Assignsmissingvaluestothespecifiedcharacterornumericvariables.

CALLSCANRoutine

Returnsthepositionandlengthofthenthwordfromacharacterstring.

CATFunction

Doesnotremoveleadingortrailingblanks,andreturnsaconcatenatedcharacterstring.

CATQFunction

Concatenatescharacterornumericvaluesbyusingadelimitertoseparateitemsandbyaddingquotationmarkstostringsthatcontainthedelimiter.

CATSFunction

Removesleadingandtrailingblanks,andreturnsaconcatenatedcharacterstring.

CATTFunction

Removestrailingblanks,andreturnsaconcatenatedcharacterstring.

CATXFunction

Removesleadingandtrailingblanks,insertsdelimiters,andreturnsacharacterstring.

CHARFunction

Returnsasinglecharacterfromaspecifiedpositioninacharacterstring.

CHOOSECFunction

Returnsacharactervaluethatrepresentstheresultsofchoosingfromalistofarguments.

CHOOSENFunction

Returnsanumericvaluethatrepresentstheresultsofchoosingfromalistofarguments.

COALESCECFunction

Returnsthefirstnon-missingvaluefromalistofcharacterarguments.

COLLATEFunction

ReturnsacharacterstringinASCIIorEBCDICcollatingsequence.

COMPAREFunction

Returnsthepositionoftheleftmostcharacterbywhichtwostringsdiffer,orreturns0ifthereisnodifference.

COMPBLFunction

Removesmultipleblanksfromacharacterstring.

COMPGEDFunction

Returnsthegeneralizededitdistancebetweentwostrings.

COMPLEVFunction

ReturnstheLevenshteineditdistancebetweentwostrings.

COMPRESSFunction

Returnsacharacterstringwithspecifiedcharactersremovedfromtheoriginalstring.

COUNTFunction

Countsthenumberoftimesthataspecifiedsubstringappearswithinacharacterstring.

COUNTCFunction

Countsthenumberofcharactersinastringthatappearordonotappearinalistofcharacters.

COUNTWFunction

Countsthenumberofwordsinacharacterstring.

DEQUOTEFunction

Removesmatchingquotationmarksfromacharacterstringthatbeginswithaquotationmark,anddeletesallcharacterstotherightoftheclosingquotationmark.

FINDFunction

Searchesforaspecificsubstringofcharacterswithinacharacterstring.

FINDCFunction

Searchesastringforanycharacterinalistofcharacters.

FINDWFunction

Returnsthecharacterpositionofawordinastring,orreturnsthenumberofthewordinastring.

FIRSTFunction

Returnsthefirstcharacterinacharacterstring.

IFCFunction

Returnsacharactervaluebasedonwhetheranexpressionistrue,false,ormissing.

INDEXFunction

Searchesacharacterexpressionforastringofcharacters,andreturnsthepositionofthestring'sfirstcharacterforthefirstoccurrenceofthestring.

INDEXCFunction

Searchesacharacterexpressionforanyofthespecifiedcharacters,andreturnsthepositionofthatcharacter.

INDEXWFunction

Searchesacharacterexpressionforastringthatisspecifiedasaword,andreturnsthepositionofthefirstcharacterintheword.

LEFTFunction

Left-alignsacharacterstring.

LENGTHFunction

Returnsthelengthofanon-blankcharacterstring,excludingtrailingblanks,andreturns1forablankcharacterstring.

LENGTHCFunction

Returnsthelengthofacharacterstring,includingtrailingblanks.

LENGTHMFunction

Returnstheamountofmemory（inbytes）thatisallocatedforacharacterstring.

LENGTHNFunction

Returnsthelengthofacharacterstring,excludingtrailingblanks.

LOWCASEFunction

Convertsalllettersinanargumenttolowercase.

MD5Function

Returnstheresultofthemessagedigestofaspecifiedstring.

MISSINGFunction

Returnsanumericresultthatindicateswhethertheargumentcontainsamissingvalue.

NLITERALFunction

ConvertsacharacterstringthatyouspecifytoaSASnameliteral.

NOTALNUMFunction

Searchesacharacterstringforanon-alphanumericcharacter,andreturnsthefirstpositionatwhichthecharacterisfound.

NOTALPHAFunction

Searchesacharacterstringforanonalphabeticcharacter,andreturnsthefirstpositionatwhichthecharacterisfound.

NOTCNTRLFunction

Searchesacharacterstringforacharacterthatisnotacontrolcharacter,andreturnsthefirstpositionatwhichthatcharacterisfound.

NOTDIGITFunction

Searchesacharacterstringforanycharacterthatisnotadigit,andreturnsthefirstpositionatwhichthatcharacterisfound.

NOTFIRSTFunction

SearchesacharacterstringforaninvalidfirstcharacterinaSASvariablenameunderVALIDVARNAME=V7,andreturnsthefirstpositionatwhichthatcharacterisfound.

NOTGRAPHFunction

Searchesacharacterstringforanon-graphicalcharacter,andreturnsthefirstpositionatwhichthatcharacterisfound.

NOTLOWERFunction

Searchesacharacterstringforacharacterthatisnotalowercaseletter,andreturnsthefirstpositionatwhichthatcharacterisfound.

NOTNAMEFunction

SearchesacharacterstringforaninvalidcharacterinaSASvariablenameunderVALIDVARNAME=V7,andreturnsthefirstpositionatwhichthatcharacterisfound.

NOTPRINTFunction

Searchesacharacterstringforanonprintablecharacter,andreturnsthefirstpositionatwhichthatcharacterisfound.

NOTPUNCTFunction

Searchesacharacterstringforacharacterthatisnotapunctuation