Difference between revisions of "Functions by category"

m
m
Line 9: Line 9:
  
 
== Language, control, and syntax ==
 
== Language, control, and syntax ==
−
'''[[Operators]]: '''Arithmetic: + - * / ^  Comparison: =  <  >  <>  <=  >=  Logical:  [[And]], [[Or]], [[Not]]; Text concatenation: &; Subscript and slice: [[Subscript/Slice Operator| x[I=x], x[@I=x] ]] :Assignment: :=, Reference: \, Dereference: #,  
+
'''[[Operators]]: '''Arithmetic: + - * / ^  [[Comparison Operators|Comparison]]: =  <  >  <>  <=  >=  [[Logical Operators|Logical]]:  [[And]], [[Or]], [[Not]]; [[Text Concatenation Operator: &|Text concatenation]]: &; [[Subscript-Slice Operator|Subscript]] and slice: [[Subscript/Slice Operator| x[I=x], x[@I=x] ]], [[Assignment Operator|Assignment]]: :=, [[Reference]]: \, [[Dereference Operator|Dereference]]: #,  
  
 
'''Conditional constructs:''' [[If-Then-Else]], [[Ifall-Then-Else]], [[Ifonly-Then-Else]], [[If0]], [[Ifpos]]
 
'''Conditional constructs:''' [[If-Then-Else]], [[Ifall-Then-Else]], [[Ifonly-Then-Else]], [[If0]], [[Ifpos]]
Line 24: Line 24:
 
'''Basic math:''' [[Abs]], [[Sign]], [[Mod]], [[Round]], [[Ceil]], [[Floor]], [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]], [[Factorial]], [[Degrees]], [[Radians]]
 
'''Basic math:''' [[Abs]], [[Sign]], [[Mod]], [[Round]], [[Ceil]], [[Floor]], [[Sqr]], [[Sqrt]], [[Exp]], [[Ln]], [[LogTen]], [[Factorial]], [[Degrees]], [[Radians]]
  
−
'''Trigonometry: '''[[Trig Functions| Sin, Cos, Tan]];[[Trig Functions| Sinh, Cosh, Tanh]]; [[ArcSin]], [[ArcCos]], [[ArcTan]], [[ArcTan2]]; [[ArcSinH]],  [[ArcCosH]], [[ArcTanH]]
+
'''Trigonometry: '''[[Trig Functions| Sin, Cos, Tan]][[Trig Functions| Sinh, Cosh, Tanh]]; [[ArcSin]], [[ArcCos]], [[ArcTan]], [[ArcTan2]]; [[ArcSinH]],  [[ArcCosH]], [[ArcTanH]]
  
−
'''Complex numbers:''' [[RealPart]], [[ImPart]], [[ComplexDegrees]], [[ComplexRadians]], [[Conj]]
+
'''[[Complex Numbers|Complex numbers]]:''' [[RealPart]], [[ImPart]], [[ComplexDegrees]], [[ComplexRadians]], [[Conj]]
  
 
==Statistics and Probability distributions==
 
==Statistics and Probability distributions==
−
'''Statistics: '''[[Median]], [[Mean]],  [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]], [[Statistics]], [[Probability]], [[GetFract]],  [[ProbBands]]
+
'''[[Statistics]]: '''[[Median]], [[Mean]],  [[SDeviation]], [[Variance]], [[Skewness]], [[Kurtosis]], [[Statistics]], [[Probability]], [[GetFract]],  [[ProbBands]], [[Correlation]], [[RankCorrel]], [[Regression]], [[Cdf]],  [[Pdf]]
−
* [[Correlation]], [[RankCorrel]], [[Regression]]
+
 
−
* [[Cdf]],  [[Pdf]]
 
 
'''Custom distributions: '''[[CumDist]], [[Fractiles]], [[ChanceDist]], [[ProbDist]], [[ProbTable]], [[Random]]
 
'''Custom distributions: '''[[CumDist]], [[Fractiles]], [[ChanceDist]], [[ProbDist]], [[ProbTable]], [[Random]]
  
Line 45: Line 44:
  
 
=== Other types of data ===
 
=== Other types of data ===
−
;Date and Time: [[Today]], [[Date_Functions#MakeDate.28year.2C_month.2C_day.29| MakeDate]], [[DateAdd]], [[DatePart]]
+
'''Date and Time:'''[[Date_Functions#MakeDate.28year.2C_month.2C_day.29| '''MakeDate''']], [[DateAdd]], [[DatePart]], [[Today]]
−
;'''Text functions: '''[[SelectText]],  [[FindInText]], [[TextReplace]], [[SplitText]], [[JoinText]], [[Text Concatenation Operator: &|Text Concatenation: t1&]]<nowiki/>t2 [[TextLength]], [[TextLowerCase]], [[TextUpperCase]], [[TextSentenceCase]], [[TextTrim]]
+
 
−
<nowiki/>== Array functions ==
+
[[Text values|'''Text''']]''': [[SelectText]],  [[FindInText]], [[TextReplace]], [[SplitText]], [[JoinText]], [[Text Concatenation Operator: &|Text Concatenation]]: t1&<nowiki/>t2 [[TextLength]], [[TextLowerCase]], [[TextUpperCase]], [[TextSentenceCase]], [[TextTrim]]'''<nowiki/>
 +
 
 +
=== Array functions ===
 
'''Make an Index: '''[[Sequence]],  [[Sequence Operator|Sequence Operator: first..last]], [[SortIndex]], [[SplitText]], [[SubIndex]], [[Subset]], [[Unique]]
 
'''Make an Index: '''[[Sequence]],  [[Sequence Operator|Sequence Operator: first..last]], [[SortIndex]], [[SplitText]], [[SubIndex]], [[Subset]], [[Unique]]
  
Line 54: Line 55:
 
'''Subscript, selection, lookup: '''[[Slice]], [[Subscript]], [[StepInterp]], [[Subscript/Slice Operator|Slice Operator: [@I=n] ]]
 
'''Subscript, selection, lookup: '''[[Slice]], [[Subscript]], [[StepInterp]], [[Subscript/Slice Operator|Slice Operator: [@I=n] ]]
  
−
'''Array mapping: '''
+
'''Array mapping: '''[[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]], [[Integrate]], [[Rank]], [[Sort]], [[Aggregate]]
−
* [[Cumulate]], [[Uncumulate]], [[CumProduct]], [[Normalize]], [[Integrate]]
+
 
−
* [[Rank]], [[Sort]]
 
−
* [[Aggregate]]
 
 
'''Tables and functions to make arrays: '''[[Array]], [[Table]], [[SubTable]], [[MultiTable]], [[DetermTable]], [[ProbTable]], [[AddIndex]]
 
'''Tables and functions to make arrays: '''[[Array]], [[Table]], [[SubTable]], [[MultiTable]], [[DetermTable]], [[ProbTable]], [[AddIndex]]
  
Line 63: Line 62:
  
 
'''Matrix: '''[[MatrixMultiply]], [[Transpose]], [[Invert]], [[Determinant]], [[Decompose]],  [[EigenDecomp]], [[SingularValueDecomp]]
 
'''Matrix: '''[[MatrixMultiply]], [[Transpose]], [[Invert]], [[Determinant]], [[Decompose]],  [[EigenDecomp]], [[SingularValueDecomp]]
 +
 
'''Information about arrays: '''[[Size]], [[IndexesOf]], [[IndexNames]], [[MemoryInUseBy]]
 
'''Information about arrays: '''[[Size]], [[IndexesOf]], [[IndexNames]], [[MemoryInUseBy]]
  
−
'''Relational tables: '''[[MdTable]], [[MdArrayToTable]]
+
'''Relational tables: '''[[MdTable]], [[MdArrayToTable]]
−
* [[Aggregate]]
 
−
'''Other array functions'''
 
−
 
 
−
'''Functions that make indexes:''' [[SortIndex]], [[Split]], [[SubIndex]], [[Subset]], [[Unique]]
 
  
−
== Financial ==
+
'''Other array functions: [[Aggregate]]
 +
'''
  
−
* [[Pv]], [[Fv]], [[Npv]], [[XNpv]], [[Rate]], [[NPer]], [[Pmt]], [[PPmt]], [[IPmt]], [[CumIPmt]], [[Irr]], [[XIrr]]
+
'''Financial''': [[Pv]], [[Fv]], [[Npv]], [[XNpv]], [[Rate]], [[NPer]], [[Pmt]], [[PPmt]], [[IPmt]], [[CumIPmt]], [[Irr]], [[XIrr]]
  
 
== User interaction and dialog ==
 
== User interaction and dialog ==
Line 83: Line 80:
  
 
* [[Chr]], [[Asc]]
 
* [[Chr]], [[Asc]]
−
* [[NumberToText]], [[Coerce_to_Numeric]]    (Flat file library.ana)
+
* [[NumberToText]]
 
* [[ParseDate]], [[ParseNumber]]
 
* [[ParseDate]], [[ParseNumber]]
 
* [[Data_Type_Functions#Function_IsNotSpecified|IsNotSpecified]]
 
* [[Data_Type_Functions#Function_IsNotSpecified|IsNotSpecified]]
−
'''Get or test type:''' [[Data_Type_Functions#Function_TypeOf| TypeOf]], [[IsDateTime]], [[IsHandle]], [[Data_Type_Functions#Function_IsNaN| IsNaN]], [[IsNull]],[[Data_Type_Functions#Function_IsNumber| IsNumber]], [[IsRealNumber]],[[Data_Type_Functions#Function_IsReference| IsReference]],[[Data_Type_Functions#Function_IsText| IsText]], [[Data_Type_Functions#Function_IsUndef| IsUndef]]
+
'''Get or test type:''' [[Data_Type_Functions#Function_TypeOf| TypeOf]], [[IsDateTime]], [[IsHandle]], [[Data_Type_Functions#Function_IsNaN| IsNaN]], [[IsNull]],[[Data_Type_Functions#Function_IsNumber| IsNumber]], [[IsRealNumber]],[[Data_Type_Functions#Function_IsReference| IsReference]],[[Data_Type_Functions#Function_IsText| IsText]], [[Data_Type_Functions#Function_IsUndef| IsUndef]], [[IsResultComputed]]
−
* [[IsResultComputed]]
 
−
 
 
 
== Integration with other applications ==
 
== Integration with other applications ==
  
 
*  [[RunConsoleProcess]]
 
*  [[RunConsoleProcess]]
−
'''Reading data: '''[[ReadFromUrl]], [[OpenURL]], [[ReadImageFile]], [[ReadTextFile]], [[WriteTextFile]], [[ShowPdfFile]]
+
'''Reading and writing data: '''[[ReadFromUrl]], [[OpenURL]], [[ReadImageFile]], [[ReadTextFile]], [[WriteTextFile]], [[ShowPdfFile]]
  
 
'''Spreadsheet access: '''[[SpreadsheetOpen]], [[SpreadsheetSave]], [[SpreadsheetCell]], [[SpreadsheetRange]], [[SpreadsheetSetCell]], [[SpreadsheetSetRange]], [[SpreadsheetInfo]], [[SpreadsheetSetInfo]]
 
'''Spreadsheet access: '''[[SpreadsheetOpen]], [[SpreadsheetSave]], [[SpreadsheetCell]], [[SpreadsheetRange]], [[SpreadsheetSetCell]], [[SpreadsheetSetRange]], [[SpreadsheetInfo]], [[SpreadsheetSetInfo]]
  
 +
'''Database and ODBC access: '''[[SqlDriverInfo]], [[DbLabels]], [[DbQuery]], [[DbTable]], [[DbTablenames]], [[DbWrite]], [[MdxQuery]]
  
−
* [[OpenExcelFile]]  -- depreciated: use [[SpreadsheetOpen]]
+
'''COM API: '''[[COMArray]], [[COMCallMethod]], [[COMCreateObject]], [[COMGetProperty]]
−
 
 
−
=== Database and ODBC access ===
 
−
 
 
−
* [[SqlDriverInfo]]
 
−
* [[DbLabels]]
 
−
* [[DbQuery]]
 
−
* [[DbTable]]
 
−
* [[DbTablenames]]
 
−
* [[DbWrite]]
 
−
* [[MdxQuery]]
 
−
 
 
−
=== COM API ===
 
−
 
 
−
* [[COMArray]]
 
−
* [[COMCallMethod]]
 
−
* [[COMCreateObject]]
 
−
* [[COMGetProperty]]
 
−
 
 
−
=== Error handling ===
 
  
−
* [[Error]]
+
'''Error handling:''' [[Error]], [[IgnoreWarnings]], [[Try]], [[ReThrow]]
−
* [[IgnoreWarnings]]
 
−
* [[Try]], [[ReThrow]]
 
  
−
== Set functions ==
+
'''Set functions: '''[[SetContains]], [[SetDifference]], [[SetEvaluationFlag]], [[SetIntersection]], [[SetUnion]]
−
* [[SetContains]]
 
−
* [[SetDifference]]
 
−
* [[SetEvaluationFlag]]
 
−
* [[SetIntersection]]
 
−
* [[SetUnion]]
 
  
  
Line 135: Line 105:
 
== Objects and meta-inference ==
 
== Objects and meta-inference ==
  
−
* [[ListOfHandles]]
+
* [[ListOfHandles]], [[Dereference Operator::#|Dereference Operator: #R]] [[VarTerm Functions#Function_IndexesOf| IndexesOf]], [[IndexNames]], [[VarTerm Functions#Function_GetVariableByName| GetVariableByName]], [[IndexValue]], [[AttribGet]]
−
* [[Dereference Operator::#|Dereference Operator: #R]] : Return the value pointed to by a reference R.
 
−
* [[VarTerm Functions#Function_IndexesOf| IndexesOf]], [[IndexNames]]
 
−
* [[VarTerm Functions#Function_GetVariableByName| GetVariableByName]]
 
−
* [[IndexValue]]
 
−
* [[AttribGet]]
 
  
 
=== User modifiable attributes ===
 
=== User modifiable attributes ===
Line 168: Line 133:
 
=== Analytica environment information ===
 
=== Analytica environment information ===
  
−
* [[AnalyticaLicenseInfo]], [[GetProcessInfo]]
+
* [[AnalyticaLicenseInfo]], [[GetProcessInfo]], [[GetRegistryValue]], [[MemoryInUseBy]]
−
* [[GetRegistryValue]]
 
−
* [[MemoryInUseBy]]
 
  
 
== Function parameter qualifiers ==
 
== Function parameter qualifiers ==

Revision as of 03:48, 13 November 2015

Function list (to be categorized) (Back to Analytica Reference)

See also: functions by category. Functions to be organized Rare and deprecated functions

Language, control, and syntax

Operators: Arithmetic: + - * / ^ Comparison: = < > <> <= >= Logical: And, Or, Not; Text concatenation: &; Subscript and slice: x[I=x], x[@I=x] , Assignment: :=, Reference: \, Dereference: #,

Conditional constructs: If-Then-Else, Ifall-Then-Else, Ifonly-Then-Else, If0, Ifpos

Loops: While..Do, For..Do

Grouped expressions: (expr; expr), BEGIN expr; expr END

Comments: { commented text }

Declaring local variables: Using x DO; Var x; Index i; MetaVar v; MetaIndex i; Alias a

Mathematics

Basic math: Abs, Sign, Mod, Round, Ceil, Floor, Sqr, Sqrt, Exp, Ln, LogTen, Factorial, Degrees, Radians

Trigonometry: Sin, Cos, Tan Sinh, Cosh, Tanh; ArcSin, ArcCos, ArcTan, ArcTan2; ArcSinH, ArcCosH, ArcTanH

Complex numbers: RealPart, ImPart, ComplexDegrees, ComplexRadians, Conj

Statistics and Probability distributions

Statistics: Median, Mean, SDeviation, Variance, Skewness, Kurtosis, Statistics, Probability, GetFract, ProbBands, Correlation, RankCorrel, Regression, Cdf, Pdf

Custom distributions: CumDist, Fractiles, ChanceDist, ProbDist, ProbTable, Random

Discrete distributions: Bernoulli, Binomial, NegativeBinomial, Combinations, Permutations, Geometric, HyperGeometric, Certain

Continuous distribution functions: Uniform, Normal, LogNormal, Beta, Triangular, Poisson, Exponential, Gamma, StudentT, Weibull, Wilcoxon, Logistic, BesselJ, BesselY, BesselI, BesselK, ChiSquared

Modifying distributions: Mid, Sample, Truncate, Shuffle

Functions for distributions: ProbWilcoxon, CumWilcoxon, CumWilcoxonInv, BetaI, BetaIInv, GammaI, GammaIInv, CumNormal, CumNormalInv

SIPs and SLURPs: SipDecode, SipEncode

Other types of data

Date and Time: MakeDate, DateAdd, DatePart, Today

Text: SelectText, FindInText, TextReplace, SplitText, JoinText, Text Concatenation: t1&t2 TextLength, TextLowerCase, TextUpperCase, TextSentenceCase, TextTrim

Array functions

Make an Index: Sequence, Sequence Operator: first..last, SortIndex, SplitText, SubIndex, Subset, Unique

Array reducing: Sum, Product, Average, Max Min, ArgMin_and_ArgMax, JoinText, Condmax, Condmin, Area

Subscript, selection, lookup: Slice, Subscript, StepInterp, Slice Operator: [@I=n]

Array mapping: Cumulate, Uncumulate, CumProduct, Normalize, Integrate, Rank, Sort, Aggregate

Tables and functions to make arrays: Array, Table, SubTable, MultiTable, DetermTable, ProbTable, AddIndex

Interpolation: StepInterp, LinearInterp, CubicInterp, MonoCubicInterp

Matrix: MatrixMultiply, Transpose, Invert, Determinant, Decompose, EigenDecomp, SingularValueDecomp

Information about arrays: Size, IndexesOf, IndexNames, MemoryInUseBy

Relational tables: MdTable, MdArrayToTable

Other array functions: Aggregate

Financial: Pv, Fv, Npv, XNpv, Rate, NPer, Pmt, PPmt, IPmt, CumIPmt, Irr, XIrr

User interaction and dialog

User input: Choice, Checkbox

Dialog boxes: MsgBox, Error, AskMsgText, AskMsgChoice, AskMsgNumber, ShowProgressBar

Types and type conversion

Get or test type: TypeOf, IsDateTime, IsHandle, IsNaN, IsNull, IsNumber, IsRealNumber, IsReference, IsText, IsUndef, IsResultComputed

Integration with other applications

Reading and writing data: ReadFromUrl, OpenURL, ReadImageFile, ReadTextFile, WriteTextFile, ShowPdfFile

Spreadsheet access: SpreadsheetOpen, SpreadsheetSave, SpreadsheetCell, SpreadsheetRange, SpreadsheetSetCell, SpreadsheetSetRange, SpreadsheetInfo, SpreadsheetSetInfo

Database and ODBC access: SqlDriverInfo, DbLabels, DbQuery, DbTable, DbTablenames, DbWrite, MdxQuery

COM API: COMArray, COMCallMethod, COMCreateObject, COMGetProperty

Error handling: Error, IgnoreWarnings, Try, ReThrow

Set functions: SetContains, SetDifference, SetEvaluationFlag, SetIntersection, SetUnion


Objects and meta-inference

User modifiable attributes

Other common attributes

Rare attributes

Sensitivity analysis

Special

Evaluation

Analytica environment information

Function parameter qualifiers

  • Type: Boolean, Integer, Index, Variable, Handle
  • Optional, Repeated
  • Scalar, Vector, Array

Functions still to be categorized


Linked List Library.ana: LL_First, LL_Length (Linked List Library.ana)


Multivariate Distributions.ana: Multinomial, MultiNormal, MultiUniform, Normal_additive_gro, Normal_compound_gro, Normal_correl, Normal_serial_correl


Optimizer functions

Obsolete optimizer

Comments


You are not allowed to post comments.