OpenLLM-France/wikimedia huggingface dataset:
# SQL Dialects Reference/Functions and expressions/Math functions/Trigonometric functions
#### Trigonometric functions

This page includes comparison tables which can be big and complex.
While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.
| SQL version | Feature | Standard SQL:2011 | DB2 | Firebird | Ingres | Linter | MSSQL | MySQL Vers. 5.x | MonetDB | Oracle Vers. 11.x | PostgreSQL | SQLite | Virtuoso |
| ? | Arc sine | N/A | ASIN(x) | ASIN(x) | ASIN(X) | ASIN(x) | ASIN(x) | ASIN(x) | ASIN(x) | ASIN(x) | ASIN(x) | N/A | ASIN(x) |
| ? | Arc cosine | N/A | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | ACOS(x) | N/A | ACOS(x) |
| ? | Arc tangent of x | N/A | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | ATAN(x) | N/A | ATAN(x) |
| ? | Arc tangent of x and y | N/A | ATAN2(x, y) | ATAN2(x,y) | ATAN2(x, y) | ATAN2(x, y) | ATN2(x, y) | ATAN2(x, y) ATAN(x, y) | ATAN2(x,y) | ATAN2(x, y) ATAN2(x / y) | ATAN2(x,y) | N/A | ATAN2(x, y) |
| ? | Sine | N/A | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | SIN(x) | N/A | SIN(x) |
| ? | Cosine | N/A | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | COS(x) | N/A | COS(x) |
| ? | Tangent | N/A | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | TAN(x) | N/A | TAN(x) |
| ? | Cotangent | N/A | COT(x) | COT(x) | N/A | N/A | COT(x) | COT(x) | COT(x) | N/A | COT(x) | N/A | COT(x) |
| ? | Hyperbolic sine | N/A | SINH(x) | SINH(x) | N/A | SINH(x) | N/A | N/A | SINH(x) | SINH(x) | N/A | N/A | N/A |
| ? | Hyperbolic cosine | N/A | COSH(x) | COSH(x) | N/A | COSH(x) | N/A | N/A | COSH(x) | COSH(x) | N/A | N/A | N/A |
| ? | Hyperbolic tangent | N/A | TANH(x) | TANH(x) | N/A | TANH(x) | N/A | N/A | TANH(x) | TANH(x) | N/A | N/A | N/A |
| ? | Hyperbolic arctangent | N/A | ATANH(x) | ATANH(x) | N/A | ? | N/A | N/A | N/A | N/A | N/A | N/A | ? |
# SQL Dialects Reference/Functions and expressions/Misc expressions
### Misc functions

This page includes comparison tables which can be big and complex.
While it's perfectly all right to view them in their complete state, it is recommended to install a comparison tables extension that would allow to select particular columns of interest for comparison.
| SQL version | Feature | Standard SQL:2011 | DB2 | Firebird | Ingres | Linter | MSSQL | MySQL Vers. 5.x | MonetDB | Oracle Vers. 11.x | PostgreSQL | SQLite | Virtuoso |
| ? | Convert value val to data type type | CAST(val AS type) | ? | CAST(val AS type) | ? | CAST(val AS type) CASTexpression as type TO_CHAR TO_NUMBER TO_DATE | CAST(val AS type) CONVERT(type, val, style) | CONVERT(val, type) CAST(val AS type) | CAST(val AS type) CONVERT(val, type) | CAST(val AS type) | CAST(val AS type) val::type | CAST(val AS type) | ? |
| ? | Replace NULL within a val with a fallback value, return val intact, if it's non-NULL | COALESCE(val, fallback) | ? | ? | ? | NVL(val, fallback) | COALESCE(val, fallback) ISNULL(val, fallback) | IFNULL(val, fallback) | COALESCE(val, fallback) | COALESCE(val, fallback) NVL(val, fallback) | COALESCE(val, fallback) | IFNULL(val, fallback) COALESCE(val, fallback) | ? |
| ? | Return the first non-NULL value from a list of values (val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2) | COALESCE(val1, val2, ...) | ? | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | COALESCE(val1, val2, ...) | ? |
| ? | Convert particular values to NULL: return NULL if a = b otherwise keep a | NULLIF(a, b) | ? | NULLIF(a, b) | ? | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | NULLIF(a, b) | ? |
# SQL Dialects Reference/Procedural language/Stored procedures
### Stored procedures

| Database | Create syntax | Calling |
| DB2 | CREATE PROCEDURE procedure_name(...) BEGIN /* SQL code */ END | CALL procedure_name(...) |
| Firebird | SET TERM $$ ; CREATE PROCEDURE nameprocedure (input_parameter_name datatype, ... ) RETURNS (output_parameter_name datatype, ... ) AS DECLARE VARIABLE variable_name datatype; BEGIN /* SQL code */ END$$ SET TERM ; $$ | SELECT ... FROM function_name(...) EXECUTE function_name(...) |
| MonetDB | CREATE [ OR REPLACE ] PROCEDURE procedure_name(...) BEGIN /* SQL code */ END CREATE [ OR REPLACE ] PROCEDURE procedure_name(...) EXTERNAL NAME MAL_procedure_name | CALL procedure_name(...) |
| MySQL | DELIMITER $$ CREATE PROCEDURE nameprocedure (input_parameter_name datatype, ... ) BEGIN /* SQL code */ END$$ DELIMITER ; | CALL nameprocedure(...) |
| Linter | CREATE [OR REPLACE] PROCEDURE procedure_name([IN/OUT/INOUT] parameter_name datatype, ...) [RESULT datatype] [FOR DEBUG] DECLARE /* variables declaration */ CODE /* stored procedure code (including SQL code)*/ EXCEPTIONS /* exceptions declarations */ END | CALL procedure_name(...) EXECUTE procedure_name(...) EXECUTE procedure_name(...) AS OWNER SELECT procedure_name(...) FROM ... WHERE procedure_name(...) = ... |
| OpenLink Virtuoso | | |
| Oracle | CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] IS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [procedure_name]; | CALL [PACKAGE_NAME.]procedure_name(...); BEGIN [PACKAGE_NAME.]procedure_name(...); END; EXEC[ute] is another (client) option, which is implemented by some Oracle clients: CALL syntax can't pass BOOLEAN and other PL/SQL-only types: |
| PostgreSQL | CREATE FUNCTION function_name (input_parameter_name datatype, ...) RETURNS return_type AS $$ DECLARE variable_name datatype; BEGIN /* SQL code */ END; $$ LANGUAGE plpgsql; | SELECT function_name(...) |
| SQL Server | CREATE PROCEDURE nameprocedure (input_parameter_name datatype, ... ) AS /* SQL code */ GO | EXEC nameprocedure(...) |
| SQLite | N/A | N/A |
* 1 2 Oracle SQL Stored Procedures Call vs. Execute discussion on CALL vs EXEC[ute] command in SQL*Plus and other clients.
# SQL Dialects Reference/Procedural language/User-defined functions
### User-defined functions (UDF)

| Database | Create syntax | Calling |
| DB2 | CREATE FUNCTION function_name (input_parameter_name datatype, ...) RETURNS return_type BEGIN /* SQL code */ END | VALUES function_name(...) or SELECT function_name(...) FROM ... WHERE function_name(...) = ... |
| MonetDB | CREATE [ OR REPLACE ] FUNCTION function_name (input_parameter_name datatype, ...) RETURNS return_type /* return type can also be a table structure */ BEGIN /* SQL code */ END CREATE [ OR REPLACE ] FUNCTION function_name (input_parameter_name datatype, ...) RETURNS return_type /* return type can also be a table structure */ LANGUAGE { C | CPP | R | PYTHON3 | PYTHON3_MAP } { function_body_in_language_syntax } CREATE [ OR REPLACE ] FUNCTION function_name (input_parameter_name datatype, ...) RETURNS return_type /* return type can also be a table structure */ EXTERNAL NAME MAL_function_name | SELECT function_name(...) /* when the return type of the function is a table, following is allowed */ SELECT ... FROM function_name(...) |
| MySQL | DELIMITER $$ CREATE FUNCTION function_name (input_parameter_name datatype, ... ) RETURNS datatype BEGIN RETURN /* SQL code */ END$$ DELIMITER ; | SELECT function_name(...) |
| PostgreSQL | CREATE FUNCTION function_name (input_parameter_name datatype, ...) RETURNS datatype AS $$ DECLARE variable_name datatype; BEGIN /* SQL code */ END; $$ LANGUAGE plpgsql; | SELECT function_name(...) |
| Firebird | UDFs are written in external tools and compiled into executable form. They are dynamically loaded at runtime. In order for server to pick them up, they need to be registered, like this: DECLARE EXTERNAL FUNCTION function_name [datatype, ...] RETURNS datatype ENTRY_POINT 'entryname' MODULE_NAME 'modulename'; | SELECT function_name(...) |
| OpenLink Virtuoso | | |
| Oracle | CREATE OR REPLACE my_function(p_contract IN VARCHAR2, p_org_id IN VARCHAR2) RETURN DATE AS l_ret_eff_date DATE := SYSDATE; BEGIN RETURN l_ret_eff_date; END; / | SELECT my_function('PARM1', 'ORG1') FROM dual; |
| SQLite | N/A | N/A |
| SQL Server | | |
# SQL Dialects Reference/References
## Standards

* SQL-86
* SQL-89
* SQL-92 — full text is available
* SQL:1999 — can be purchased from ISO
* SQL:2003 — can be purchased from ISO
* working draft of SQL:2008, downloadable from Whitemarsh Information Systems Corporation.
* SQL:2008 — can be purchased from ISO
* SQL:2011 — can be purchased from ISO

## Official product documentations

* DB2 Version 9 Information Center
* MonetDB documentation
* MySQL 5.0 reference manual
* PostgreSQL 8.2 reference manual
* SQLite documentation
* Firebird / Interbase 6 language reference (ZIP archive, 8.9MB)
* OpenLink Virtuoso Universal Server Documentation
* Oracle Database 10g2 SQL Reference
* Oracle Database 12g1 SQL Reference
* Microsoft SQL Server Documentation
* Linter SQL Server Documentation (English, old version);Linter SQL Server Documentation (Russian)

## Single implementation references and cheat sheets

* Oracle PL/SQL Cheatsheet
* Oracle XML Cheatsheet

## Comparisons

* Comparison of different SQL implementations
* Comparison of Oracle, MySQL and PostgreSQL DBMS by Computing Division of Fermi National Accelerator Laboratory
* SQL Function Reference: Oracle vs. SQL Server
* Kline, Kevin E. (2001). "SQL Functions". SQL in a Nutshell. Cambridge, MS: O'Reilly. ISBN 1-56592-744-3. {{cite book}}: Unknown parameter |chapterurl= ignored (|chapter-url= suggested) (help); Unknown parameter |coauthors= ignored (|author= suggested) (help); Unknown parameter |month= ignored (help)
* SQL Functions — MySQL vs Oracle comparison by Eric Brian
* Standard SQL - an article by Peter Gulutzan that compares SQL standards support in DB2, MSSQL and Oracle

## Migration

* Converting MySQL to PostgreSQL
# William Shakespeare's Works/Comedies/As You Like It
## About the Play

As You Like It is a comedy by William Shakespeare written between 1599 and 1600. While the plot is meant to take place primarily in a duchy of France, the majority of the action actually takes place in the Forest of Arden.
The text for the play itself can be found at the bottom of the page. The purpose of this Wikibook is as a study guide.

## Acts

* Act I
* Act II
* Act III
* Act IV
* Act V

## Dramatis Personæ

* Duke Senior
* Duke Frederick
* Amiens
* Jacques
* Oliver
* Jacques de Boys
* Orlando
* Le Beau
* Charles
* Adam
* Dennis
* Touchstone
* Sir Oliver Martext
* Corin and Silvius
* William
* Hymen
* Rosalind
* Celia
* Phoebe
* Audrey
# William Shakespeare's Works/Comedies/A Midsummer Night's Dream
#### Choose an act, any act!

* Act I
* Act II
* Act III
* Act IV
* Act V

#### About this Play

This play was written between 1595 and 1596. This is one of his early wedding comedies, and was written to accompany a marriage celebration. Unlike most of Shakespeare's other works, there is very little borrowing from other works. (For example, Romeo and Juliet is based on The Tragedie of Romeus and Juliet.) Most scholars agree that Shakespeare enjoyed writing this play more than any other one.
The play's main plot circles around two couples: Hermia and Lysander, and Helena and Demetrius. Their problems become greater as they enter the fairyland woods, and as the monarchs of the fairies, King Oberon and Queen Titania, mess up the relationships.
This play emphasizes themes of love, dreams, imagination, and the power of a patriarchal society.
# Act III, Scenes V-VII
## Summary

Meanwhile, Helena has gone to Florence, where she overhears a conversation between an old Widow, her daughter Diana, and their neighbor Mariana. It seems that Bertram, who rides by with the Duke of Florence's army as they talk, has been making overtures to Diana, hoping to get her in his bed. Helena joins the discussion, in which the older woman advises Diana to maintain her chastity. The three Florentine women have heard that Bertram has a wife he detests, but are unaware that Helena is the woman. After the conversation, Helena is invited to stay with the Widow.
In the Duke's camp, the First Lord and Second Lord Dumaine advise Bertram not to put his faith in Parolles, because the man is a boastful coward with no military experience and no loyalty. To expose Parolles, they devise a plan: they will goad him into attempting to retrieve his regiment's drum, which was lost on the field of battle (a military disgrace); then, disguises as enemy soldiers, they will "capture" him, blindfold him, and interrogate him, thus demonstrating to Bertram how quickly his loyal friend will turn traitor if his life is threatened. Encountering Parolles, they suggest that the loss of the drum was unimportant, and that he should forget it. Being cocky and boastful, Bertram's companion immediately swears that he will recapture it, or at least make a valiant effort. When he is gone, the two lords laugh, and tell Bertram that Parolles will do no such thing, being a coward. Bertram is skeptical, but invites the Second Lord to accompany him and meet Diana, whom he still plans to bed.
Meanwhile, Helena has revealed her identity to the Widow, and uses a purse of gold to buy her help in a scheme that, Helena hopes, will fulfill her husband's conditions for their marriage.
# William Shakespeare's Works/Comedies/Love's Labours Lost

Love's Labours Lost is a comedy written by William Shakespeare between 1595 and 1596. The plot revolves around the romantic misadventures of the King of Navarre, the Princess of France, his companions and her companions.

## Acts

* Act 1
* Act 2
* Act 3
* Act 4
* Act 5

## Dramatis Personæ

* Ferdinand
* Berowne
* Longaville
* Dumaine
* Boyet
* Marcade
* Don Adriano de Armado
* Sir Nathaniel
* Holofernes
* Dull
* Costard
* Moth
* a Forester
* The Princess of France
* Rosaline
* Maria
* Katharine
* Jaquenetta
* Officers
* Attendants
* Others
# William Shakespeare's Works/Comedies/All's Well That Ends Well
## All's Well That Ends Well

This play concerns a maid, Helena, who cures the King of France of a disease, then asks for Lord Bertram's hand in marriage. Bertram obliges, then quickly flees to Italy to engage in war, hoping for death to avoid marriage. Helena is greatly hurt, and sets out on a pilgrimage, only to wind up in Florence, Italy, where she meets Bertram's new young mistress, Diana. In a perplexing "bed trick," Helena sleeps with Bertram, while Bertram believes he is sleeping with Diana. This act secures Helena's bond to Bertram, and Bertram, matured by war, consents to happily love Helena and their future child. Other characters include Lafew (Lafeu), a wise old lord; Parolles, an obsessive liar and follower of Bertram; the Countess, the mother of Bertram and stepmother of Helena; the Clown, a witty servant to the Countess; and a Widow, the mother of Diana.
* Plot Summary
* Act I, Scenes I-III (November 17, 2006)
* Act II, Scenes I-III (October 11, 2006)
* Act II, Scenes IV-V and Act III, Scenes I-IV
* Act III, Scenes V-VII (October 15, 2006)
* Act IV, Scenes I-III
* Act IV, Scenes IV-V and Act V, Scenes I-III: Study Guide
# William Shakespeare's Works/Comedies/Cymbeline

Cymbeline is a comedy by William Shakespeare around 1609. The play is an account of a fictional King of England, Cymbeline, modelled after Cunobelinus.

## Acts

* Act I
* Act II
* Act III
* Act IV
* Act V

## Dramatis Personæ

* Cymbeline
* Cloten
* Poshumus Leonatus
* Belarius
* Guiderius
* Arviragus
* Philario
* Iachimo
* Caius Lucius
* Pisanio
* Cornelius
* A Roman Captain
* Two British Captains
* A Frenchman
* two Lords
* two Gentlemen
* two Jailers
* Queen
* Imogen
* Helen
* Lords
* Ladies
* Roman Senators
* Soothsayers
* A Dutchman
* a Spaniard
* Tribunes
* Musicians
* Officers
* Captains
* Messengers
* Soldiers
* Attendants
* Apparitions
# World Stamp Catalogue/Oceania
## Stamp issuing Australasian and Pacific countries and dependent territories

* Australia - AUS
* Christmas Island (Indian Ocean) - CXR
* Cocos Island - CCK
* Fiji - FJI
* New Zealand - NZL
* Niue - NIU
* Norfolk Island - NFK
* Pitcairn - PCN
* Western or British Samoa - WSM
* Tonga - TON
# World Stamp Catalogue/Q-R
### Q

* Qatar
* Queensland

### R

* Rarotonga
* Ras al Khaima
* Republic of Ireland
* Reunion
* Rhodesia
* Romagna
* Roman State
* Romania
* Romanian Post Abroad
* Ross Dependency
* Ruanda-Urundi
* Russia
* Russia, Soviet Union (USSR)
* Russian Civil War Issues
* Russian Post Abroad
* Rwanda
* Ryuku Islands
# World Stamp Catalogue/Russia
## Russia / Россия

* Postage stamps and postal history of Russia (English)
* История почты России и Почтовые марки России (Russian)
* 1918
* 1921
* 1992
* 1993
* 1994
* 1995
* 1996
* 1997
* 1998
* 1999
* 2000
* 2001
* 2002
* 2003
* 2004
* 2005
* 2006
* 2007
* 2008
* 2009
* 2010
* 2011
* 2012
* 2013
* 2014
# World Stamp Catalogue/ONU
## United Nations Postal Administration

The United Nations (UN) is an international organization with its own postal administration.
in 1947 Argentina was the first to propose that the United Nations issue its own postage stamps. In 1951 the United Nations reached an agreement with the United States to issue stamps in U.S. currency for use only from the UN headquarters in New York. On October 24, 1951, United Nations Day, the first stamp was issued.
There are now three offices that issue stamps. New York began to issue stamps in 1951, followed by Geneva in 1969 using Swiss francs, and Vienna in 1979 using first Austrian schillings and later Euros.
The stamps issued by the UN promote the values of the organization, and so there is a strong preference for themes related to peace and development. Another strand is dedicated to flora and fauna, and natural beauty. Other subjects include space exploration, UNESCO world heritage, the family, discrimination, and road safety, among others.

## External links

* UN official website Italy
* The stamps of the United Nations, by Rossano Chiarle short article of 2007, in italian language
* The official website of the United Nations Postal Administration
# World Stamp Catalogue/Prince Edward Island
## Prince Edward Island

* Postage stamps and postal history of Prince Edward Island
| Date Issued | Denom. | Paper. | Color | Perf. | Type Die/Wmk | Subject | Design |
| 1861-01-01 | 2p | yellowish | carmine rose | 9 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861-01-01 | 3p | yellowish | blue | 9 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861-01-01 | 6p | yellowish | yellow green | 9 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861 | 1p | yellowish | yellow orange | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861 | 2p | | deep rose | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861 | 3p | | blue | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861 | 4p | | black | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861 | 6p | | blue green | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1861 | 9p | | rose lilac | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1870 | 4 1/2p | | yellow brown | 12 | Defin. | Queen Victoria | [[File:|100px]] |
| 1872 | 1c | | yellow orange | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1872 | 2c | | gray blue | 12 | Defin. | Queen Victoria | [[File:|100px]] |
| 1872 | 3c | | carmine rose | 11 1/2 | Defin. | Queen Victoria | [[File:|100px]] |
| 1872 | 4c | | yellow green | 12 | Defin. | Queen Victoria | [[File:|100px]] |
| 1872 | 6c | | black | 12 | Defin. | Queen Victoria | [[File:|100px]] |
| 1872 | 12c | | rose violet | 12 | Defin. | Queen Victoria | [[File:|100px]] |
# World Stamp Catalogue/P
### P

* Pakistan
* Palau
* Palestine
* Panama
* Papal State
* Papua New Guinea
* Paraguay
* Parma
* Penrhyn Island
* Peru
* Philippines
* Pitcairn Islands
* Poland
* Polish Post Abroad
* Portugal
* Portuguese Colonies
* Prince Edward Island (Canada)
* Prussia
* Puerto Rico
# World Stamp Catalogue/Pakistan
## Pakistan

* Postage stamps and postal history of Pakistan
* Revenue stamps of Pakistan
* Designers of Pakistani stamps
# World Stamp Catalogue/Peru

Catologo Filatélico del Perú
# R Programming/Index

R Programming
* R Basics
** Introduction
** Sample Session
** Manage your workspace
** Settings and Installation
** Documentation
** Control Structures
** Working with functions
** Debugging
** Using C or Fortran
** Utilities
** Estimation utilities
** Packages
* Data Management
** Data types
** Working with data frames
** Importing and exporting data
** Text Processing
** Times and Dates
* Graphics
** Grammar of graphics
* Publication quality output
* Descriptive Statistics
* Mathematics
** Optimization
** Probability Distributions
** Random Number Generation
* Statistical Core Methods
** Maximum Likelihood
** Method of Moments
** Bayesian Methods
** Bootstrap
** Multiple Imputation
** Nonparametric Methods
* Regression Models
** Linear Models
** Quantile Regression
** Binomial Models
** Multinomial Models
** Tobit And Selection Models
** Count Data Models
** Duration Analysis
* Time Series
* Factor Analysis
* Classification
** Ordination
** Clustering
* Network Analysis
* High Performance Computing
** Profiling R code
** Parallel computing with R
* Appendix
** Sources
** Index
This page provides tables which make it easy to find functions for usual tasks in statistics in R, SAS and Stata. Other software may also be included in the future such as SPSS.

## Data management

| Function | R | Stata | SAS |
| Merge | merge | merge / mmerge | - |
| Reshape | reshape | reshape | - |
| Expand a dataset | expand (epicalc) | expand | - |

## Descriptive Statistics

| Function | R | Stata | SAS |
| Mean | mean | mean | proc means |
| Histogram | hist | hist | - |
| Frequency table | table | ta | proc freq |

## Regression models

| Function | R | Stata | SAS |
| Least Square | lm | reg | proc reg |
| GLM | glm | glm | proc glm |
| Probit models | glm(, family = binomial(link="probit")) | probit | - |
| Logit models | glm(, family = binomial(link="logit")) | logit | - |
| Linear fixed effects model | plm( , model = "within") (plm) | xtreg , fe | - |
| Linear random effects model | plm( , model = "random") (plm) | xtreg , re | - |
| Linear quantile regression | rq (quantreg) | qreg | - |
| Ordinal logistic regression | polr (MASS) | ologit | - |
| Linear IV (2sls) | ivreg (AER) | ivreg | proc syslin (2sls) - |

## Programming

| Function | R | Stata | SAS |
| Check some condition | stopifnot | assert | - |
# R Programming/Duration Analysis

R Programming
* R Basics
** Introduction
** Sample Session
** Manage your workspace
** Settings and Installation
** Documentation
** Control Structures
** Working with functions
** Debugging
** Using C or Fortran
** Utilities
** Estimation utilities
** Packages
* Data Management
** Data types
** Working with data frames
** Importing and exporting data
** Text Processing
** Times and Dates
* Graphics
** Grammar of graphics
* Publication quality output
* Descriptive Statistics
* Mathematics
** Optimization
** Probability Distributions
** Random Number Generation
* Statistical Core Methods
** Maximum Likelihood
** Method of Moments
** Bayesian Methods
** Bootstrap
** Multiple Imputation
** Nonparametric Methods
* Regression Models
** Linear Models
** Quantile Regression
** Binomial Models
** Multinomial Models
** Tobit And Selection Models
** Count Data Models
** Duration Analysis
* Time Series
* Factor Analysis
* Classification
** Ordination
** Clustering
* Network Analysis
* High Performance Computing
** Profiling R code
** Parallel computing with R
* Appendix
** Sources
** Index
* Using R for Survival Analysis (pdf)
* See the survival package
* bootkm Bootstrap Kaplan-Meier Estimates in Hmisc package
* event.chart Flexible Event Chart for Time-to-Event Data in the Hmisc package