{"action":"created","issue":{"url":"https://api.github.com/repos/ajdamico/asdfree/issues/71","labels_url":"https://api.github.com/repos/ajdamico/asdfree/issues/71/labels{/name}","comments_url":"https://api.github.com/repos/ajdamico/asdfree/issues/71/comments","events_url":"https://api.github.com/repos/ajdamico/asdfree/issues/71/events","html_url":"https://github.com/ajdamico/asdfree/issues/71","id":124609805,"number":71,"title":"pns `dom` table does not get used in the import script","user":{"login":"ajdamico","id":216807,"avatar_url":"https://avatars.githubusercontent.com/u/216807?v=3","gravatar_id":"","url":"https://api.github.com/users/ajdamico","html_url":"https://github.com/ajdamico","followers_url":"https://api.github.com/users/ajdamico/followers","following_url":"https://api.github.com/users/ajdamico/following{/other_user}","gists_url":"https://api.github.com/users/ajdamico/gists{/gist_id}","starred_url":"https://api.github.com/users/ajdamico/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajdamico/subscriptions","organizations_url":"https://api.github.com/users/ajdamico/orgs","repos_url":"https://api.github.com/users/ajdamico/repos","events_url":"https://api.github.com/users/ajdamico/events{/privacy}","received_events_url":"https://api.github.com/users/ajdamico/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"DjalmaPessoa","id":5308071,"avatar_url":"https://avatars.githubusercontent.com/u/5308071?v=3","gravatar_id":"","url":"https://api.github.com/users/DjalmaPessoa","html_url":"https://github.com/DjalmaPessoa","followers_url":"https://api.github.com/users/DjalmaPessoa/followers","following_url":"https://api.github.com/users/DjalmaPessoa/following{/other_user}","gists_url":"https://api.github.com/users/DjalmaPessoa/gists{/gist_id}","starred_url":"https://api.github.com/users/DjalmaPessoa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DjalmaPessoa/subscriptions","organizations_url":"https://api.github.com/users/DjalmaPessoa/orgs","repos_url":"https://api.github.com/users/DjalmaPessoa/repos","events_url":"https://api.github.com/users/DjalmaPessoa/events{/privacy}","received_events_url":"https://api.github.com/users/DjalmaPessoa/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-01-02T20:19:08Z","updated_at":"2016-01-07T19:12:16Z","closed_at":null,"body":"djalma, i made some changes to the main script to get started--\r\n\r\nhttps://github.com/ajdamico/asdfree/commit/e7d9b6eb5985b5203b7b40d3ccb06142bca2888d\r\n\r\n--but the `dom` table never gets used, and i believe it should be merged onto the `pes` table before the survey design gets created?  that way, it is a rectangular file (like the censo demografico gets dom and pes merged).  **what merge fields should be used?**  so that i can merge on the household-level information\r\n\r\nusing the current version of the import file, the intersecting fields are--\r\n\r\n    > intersect(names(dom),names(pes))\r\n     [1] \"v0001\"     \"v0024\"     \"upa_pns\"   \"v0006_pns\" \"upa\"       \"v0028\"     \"v0029\"     \"v00281\"    \"v00291\"   \"v00282\"    \"v00292\"    \"v00283\"    \"v00293\" \r\n\r\nthanks!"},"comment":{"url":"https://api.github.com/repos/ajdamico/asdfree/issues/comments/169777237","html_url":"https://github.com/ajdamico/asdfree/issues/71#issuecomment-169777237","issue_url":"https://api.github.com/repos/ajdamico/asdfree/issues/71","id":169777237,"user":{"login":"DjalmaPessoa","id":5308071,"avatar_url":"https://avatars.githubusercontent.com/u/5308071?v=3","gravatar_id":"","url":"https://api.github.com/users/DjalmaPessoa","html_url":"https://github.com/DjalmaPessoa","followers_url":"https://api.github.com/users/DjalmaPessoa/followers","following_url":"https://api.github.com/users/DjalmaPessoa/following{/other_user}","gists_url":"https://api.github.com/users/DjalmaPessoa/gists{/gist_id}","starred_url":"https://api.github.com/users/DjalmaPessoa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DjalmaPessoa/subscriptions","organizations_url":"https://api.github.com/users/DjalmaPessoa/orgs","repos_url":"https://api.github.com/users/DjalmaPessoa/repos","events_url":"https://api.github.com/users/DjalmaPessoa/events{/privacy}","received_events_url":"https://api.github.com/users/DjalmaPessoa/received_events","type":"User","site_admin":false},"created_at":"2016-01-07T19:12:15Z","updated_at":"2016-01-07T19:12:15Z","body":"To merge \"dom\" and \"pes\" please use the variables:\n\nV0001 (State), V0024 (Stratum), UPA_PNS (PSU) and V0006_PNS (household\norder number in the PNS).\n\n\nNote that for people it is needed to work with two different designs:\n\n\n1.  people with age >18  answering the long questionnaire. It is defined in\nthe the data subset:\n\n\n !is.na(M001)&M001==\"1\"\n\n\n2.  For people in the whole population.\n\n\nPlease define them separately and poststratify each one\n\n\nIn the script I sent before there are examples of estimates defined for the\nthe two cases.\n\n\nTo estimate a household characteristic please use the\n\ndesign:\n\n\ndom_des  <-  subset (pes_des, C001== \"01\")\n\n\nwhere \"pes_des\" is the design for the whole population of people (2).\n\n\nThis defines the data relative to the head of the household (one for each\nhousehold), eliminating household data duplication for people living in the\nsame household in the merged file.\n\n\n\n\nOn Sun, Jan 3, 2016 at 11:05 AM, Djalma Pessoa <pessoad@gmail.com> wrote:\n\n> Hi, I'm out of town. I'll be back on wednesday.\n> Have a wonderful 2016!\n>\n> Em 2 de jan de 2016, às 18:19, Anthony Damico <notifications@github.com>\n> escreveu:\n>\n> djalma, i made some changes to the main script to get started--\n>\n>\n> https://githubcom/ajdamico/asdfree/commit/e7d9b6eb5985b5203b7b40d3ccb06142bca2888d\n>\n> --but the dom table never gets used, and i believe it should be merged\n> onto the pes table before the survey design gets created? that way, it is\n> a rectangular file (like the censo demografico gets dom and pes merged) *what\n> merge fields should be used?* so that i can merge on the household-level\n> information\n>\n> using the current version of the import file, the intersecting fields are--\n>\n> > intersect(names(dom),names(pes))\n>  [1] \"v0001\"     \"v0024\"     \"upa_pns\"   \"v0006_pns\" \"upa\"       \"v0028\"     \"v0029\"     \"v00281\"    \"v00291\"   \"v00282\"    \"v00292\"    \"v00283\"    \"v00293\"\n>\n> thanks!\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/ajdamico/asdfree/issues/71>.\n>\n>\n"}}