[R] pairwise deletion in regression models

Adel Daoud
2016-07-13T11:41:50Z

Hi



Yes, I am sure. Have a look here for SPSS e.g.:

http://www-01.ibm.com/support/docview.wss?uid=swg21475199 and here

http://www.ats.ucla.edu/stat/spss/modules/missing.htm



and for STATA here,

http://www.ats.ucla.edu/stat/stata/modules/missing.html





I know that R allows for pairwise deletion in the cor() function, but I
need it for regression analysis. The default is listwise (casewise)
deletion. Would be grateful for further input on this.





Best,

Adel

--

Adel Daoud, PhD, Researcher

*Newly published:*

* Daoud, Adel and Kohl, Sebastian, *How Much Do Sociologists Write About
Economic Topics? Using Big-Data to Test Some Conventional Views in Economic
Sociology, 1890 to 2014*. Max Planck Institute for the Study of Societies,
Discussion Paper 16/7  <http://www.mpifg.de/pu/mpifg_dp/dp16-7.pdf>

* Daoud, Adel, Bj?rn Haller?d, and Debarati Guha-Sapir, (2016) ?What Is the
Association between Absolute Child Poverty, Poor Governance, and Natural
Disasters? A Global Comparison of Some of the Realities of Climate
Change?, *PLoS
ONE* 11(4)
<http://journals.plos.org/plosone/article?id=10.1371/journal.pone.0153296>

*Shailen Nandy, Adel Daoud, David Gordon, (2016), Examining the changing
profile of undernutrition in the context of food price rises and greater
inequality, *Social Science & Medicine*, Volume 149, Pages 153?163
<http://www.sciencedirect.com/science/article/pii/S0277953615302446>


*Department of Sociology and Work Science,*

*University of Gothenburg*

Box 720

405 30, G?teborg, Sweden

Email: Adel.daoud at sociology.gu.se

Website: http://adeldaoud.se/  <http://adeldaoud.se/>

On Wed, Jul 13, 2016 at 10:53 AM, PIKAL Petr <petr.pikal at precheza.cz>
wrote:

> Hi
>
>
>
> Hm. Are you 100% sure that other software packages can do pairwise
> deletion in OLS or GLM? I am not at all familiar with them but
>
>
>
> http://www.ats.ucla.edu/stat/spss/modules/stats.htm
>
>
>
> suggests that option pairwise is available with corr and I believe the
> same option exists in cor function in R.
>
>
>
> My statistical knowledge is inferior but I just cannot imagine how whole
> model could be computed when one value is missing.
>
>
>
> Cheers
>
> Petr
>
>
>
> *From:* adeldaoud at gmail.com [mailto:adeldaoud at gmail.com] *On Behalf
Of *Adel
> Daoud
> *Sent:* Wednesday, July 13, 2016 10:00 AM
> *To:* PIKAL Petr <petr.pikal at precheza.cz>
> *Cc:* r-help <r-help at r-project.org>
> *Subject:* Re: [R] pairwise deletion in regression models
>
>
>
> Thanks Petr for the suggestion.
>
>
>
> I just took the regtools package for a quick test drive. It looks
> promising, but it still needs further development to make it a viable
> option. You will not get a standard regression output (as in lm or glm),
> only the regression coefficients (without standard errors). I will be happy
> to try it out once it is more robust.
>
>
>
> I am a bit puzzled that the R universe seems to lack a robust package that
> allows for pairwise deletion (which is standard in the otherwise poorer
> software packages STATA or SPSS?). Would be very happy if anyone can show
> me otherwise.
>
>
> Best,
>
> Adel
>
> --
>
> Adel Daoud, PhD, Researcher
>
> *Newly published:*
>
> * Daoud, Adel and Kohl, Sebastian, *How Much Do Sociologists Write About
> Economic Topics? Using Big-Data to Test Some Conventional Views in Economic
> Sociology, 1890 to 2014*. Max Planck Institute for the Study of
> Societies, Discussion Paper 16/7
> <http://www.mpifg.de/pu/mpifg_dp/dp16-7.pdf>
>
> * Daoud, Adel, Bj?rn Haller?d, and Debarati Guha-Sapir, (2016) ?What Is
> the Association between Absolute Child Poverty, Poor Governance, and
> Natural Disasters? A Global Comparison of Some of the Realities of Climate
> Change?, *PLoS ONE* 11(4)
>
<http://journals.plos.org/plosone/article?id=10.1371/journal.pone.0153296>
>
> *Shailen Nandy, Adel Daoud, David Gordon, (2016), Examining the changing
> profile of undernutrition in the context of food price rises and greater
> inequality, *Social Science & Medicine*, Volume 149, Pages 153?163
> <http://www.sciencedirect.com/science/article/pii/S0277953615302446>
>
>
>
> *Department of Sociology and Work Science,*
>
> *University of Gothenburg*
>
> Box 720
>
> 405 30, G?teborg, Sweden
>
> Email: Adel.daoud at sociology.gu.se
>
> Website: http://adeldaoud.se/  <http://adeldaoud.se/>
>
>
>
> On Wed, Jul 13, 2016 at 8:21 AM, PIKAL Petr <petr.pikal at
precheza.cz>
> wrote:
>
> Hi
>
>
>
http://stats.stackexchange.com/questions/158366/fit-multiple-regression-model-with-pairwise-deletion-or-on-a-correlation-covari
>
> The package is probably not available on CRAN but seems to be still
> maintained on github.
>
> Cheers
> Petr
>
> > -----Original Message-----
> > From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of
adel
> > daoud
> > Sent: Tuesday, July 12, 2016 8:28 PM
> > To: r-help <r-help at r-project.org>
> > Subject: [R] pairwise deletion in regression models
> >
> > Dear R users,
> >
> >
> >
> > I would like to use a pairwise deletion of missing values in linear
> regression
> > (lm or glm preferably). I want to replicate some studies done in STATA
> that
> > uses this type of deletion. What options do we have in R to work with
> > pairwise deletion? Most packages I have found do not have this option,
it
> > seems (lm, glm, plm, psych, sampleSelection).
> >
> >
> >
> > This question has been raised here
> > <
> http://r.789695.n4.nabble.com/set-the-bahavior-that-R-deal-with-missing-
> > values-td803840.html>
> > and here
> >
<http://r.789695.n4.nabble.com/Pairwise-deletion-in-a-linear-regression-
> > and-in-a-GLM-td4653004.html>,
> > but without any clear answer.
> >
> >
> >
> > Any input is welcomed
> >
> >
> >
> > Thanks in advance
> >
> >
> > Adel
> >
> >       [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide http://www.R-project.org/posting-
> > guide.html
> > and provide commented, minimal, self-contained, reproducible code.
>
> ________________________________
> Tento e-mail a jak?koliv k n?mu p?ipojen? dokumenty jsou d?v?rn? a jsou
> ur?eny pouze jeho adres?t?m.
> Jestli?e jste obdr?el(a) tento e-mail omylem, informujte laskav?
> neprodlen? jeho odes?latele. Obsah tohoto emailu i s p??lohami a jeho kopie
> vyma?te ze sv?ho syst?mu.
> Nejste-li zam??len?m adres?tem tohoto emailu, nejste opr?vn?ni tento email
> jakkoliv u??vat, roz?i?ovat, kop?rovat ?i zve?ej?ovat.
> Odes?latel e-mailu neodpov?d? za eventu?ln? ?kodu zp?sobenou modifikacemi
> ?i zpo?d?n?m p?enosu e-mailu.
>
> V p??pad?, ?e je tento e-mail sou??st? obchodn?ho jedn?n?:
> - vyhrazuje si odes?latel pr?vo ukon?it kdykoliv jedn?n? o uzav?en?
> smlouvy, a to z jak?hokoliv d?vodu i bez uveden? d?vodu.
> - a obsahuje-li nab?dku, je adres?t opr?vn?n nab?dku bezodkladn? p?ijmout;
> Odes?latel tohoto e-mailu (nab?dky) vylu?uje p?ijet? nab?dky ze strany
> p??jemce s dodatkem ?i odchylkou.
> - trv? odes?latel na tom, ?e p??slu?n? smlouva je uzav?ena teprve
> v?slovn?m dosa?en?m shody na v?ech jej?ch n?le?itostech.
> - odes?latel tohoto emailu informuje, ?e nen? opr?vn?n uzav?rat za
> spole?nost ??dn? smlouvy s v?jimkou p??pad?, kdy k tomu byl p?semn? zmocn?n
> nebo p?semn? pov??en a takov? pov??en? nebo pln? moc byly adres?tovi tohoto
> emailu p??padn? osob?, kterou adres?t zastupuje, p?edlo?eny nebo jejich
> existence je adres?tovi ?i osob? j?m zastoupen? zn?m?.
>
> This e-mail and any documents attached to it may be confidential and are
> intended only for its intended recipients.
> If you received this e-mail by mistake, please immediately inform its
> sender. Delete the contents of this e-mail with all attachments and its
> copies from your system.
> If you are not the intended recipient of this e-mail, you are not
> authorized to use, disseminate, copy or disclose this e-mail in any manner.
> The sender of this e-mail shall not be liable for any possible damage
> caused by modifications of the e-mail or by delay with transfer of the
> email.
>
> In case that this e-mail forms part of business dealings:
> - the sender reserves the right to end negotiations about entering into a
> contract in any time, for any reason, and without stating any reasoning.
> - if the e-mail contains an offer, the recipient is entitled to
> immediately accept such offer; The sender of this e-mail (offer) excludes
> any acceptance of the offer on the part of the recipient containing any
> amendment or variation.
> - the sender insists on that the respective contract is concluded only
> upon an express mutual agreement on all its aspects.
> - the sender of this e-mail informs that he/she is not authorized to enter
> into any contracts on behalf of the company except for cases in which
> he/she is expressly authorized to do so in writing, and such authorization
> or power of attorney is submitted to the recipient or the person
> represented by the recipient, or the existence of such authorization is
> known to the recipient of the person represented by the recipient.
>
>
>
> ------------------------------
> Tento e-mail a jak?koliv k n?mu p?ipojen? dokumenty jsou d?v?rn? a jsou
> ur?eny pouze jeho adres?t?m.
> Jestli?e jste obdr?el(a) tento e-mail omylem, informujte laskav?
> neprodlen? jeho odes?latele. Obsah tohoto emailu i s p??lohami a jeho kopie
> vyma?te ze sv?ho syst?mu.
> Nejste-li zam??len?m adres?tem tohoto emailu, nejste opr?vn?ni tento email
> jakkoliv u??vat, roz?i?ovat, kop?rovat ?i zve?ej?ovat.
> Odes?latel e-mailu neodpov?d? za eventu?ln? ?kodu zp?sobenou modifikacemi
> ?i zpo?d?n?m p?enosu e-mailu.
>
> V p??pad?, ?e je tento e-mail sou??st? obchodn?ho jedn?n?:
> - vyhrazuje si odes?latel pr?vo ukon?it kdykoliv jedn?n? o uzav?en?
> smlouvy, a to z jak?hokoliv d?vodu i bez uveden? d?vodu.
> - a obsahuje-li nab?dku, je adres?t opr?vn?n nab?dku bezodkladn? p?ijmout;
> Odes?latel tohoto e-mailu (nab?dky) vylu?uje p?ijet? nab?dky ze strany
> p??jemce s dodatkem ?i odchylkou.
> - trv? odes?latel na tom, ?e p??slu?n? smlouva je uzav?ena teprve
> v?slovn?m dosa?en?m shody na v?ech jej?ch n?le?itostech.
> - odes?latel tohoto emailu informuje, ?e nen? opr?vn?n uzav?rat za
> spole?nost ??dn? smlouvy s v?jimkou p??pad?, kdy k tomu byl p?semn? zmocn?n
> nebo p?semn? pov??en a takov? pov??en? nebo pln? moc byly adres?tovi tohoto
> emailu p??padn? osob?, kterou adres?t zastupuje, p?edlo?eny nebo jejich
> existence je adres?tovi ?i osob? j?m zastoupen? zn?m?.
>
> This e-mail and any documents attached to it may be confidential and are
> intended only for its intended recipients.
> If you received this e-mail by mistake, please immediately inform its
> sender. Delete the contents of this e-mail with all attachments and its
> copies from your system.
> If you are not the intended recipient of this e-mail, you are not
> authorized to use, disseminate, copy or disclose this e-mail in any manner.
> The sender of this e-mail shall not be liable for any possible damage
> caused by modifications of the e-mail or by delay with transfer of the
> email.
>
> In case that this e-mail forms part of business dealings:
> - the sender reserves the right to end negotiations about entering into a
> contract in any time, for any reason, and without stating any reasoning.
> - if the e-mail contains an offer, the recipient is entitled to
> immediately accept such offer; The sender of this e-mail (offer) excludes
> any acceptance of the offer on the part of the recipient containing any
> amendment or variation.
> - the sender insists on that the respective contract is concluded only
> upon an express mutual agreement on all its aspects.
> - the sender of this e-mail informs that he/she is not authorized to enter
> into any contracts on behalf of the company except for cases in which
> he/she is expressly authorized to do so in writing, and such authorization
> or power of attorney is submitted to the recipient or the person
> represented by the recipient, or the existence of such authorization is
> known to the recipient of the person represented by the recipient.