<html xmlns="http://www.w3.org/1999/xhtml" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office"><head><!--[if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]--></head><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:16px"><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_103046"><span id="yui_3_16_0_ym19_1_1510346106424_102996">Caros amigos, tenho uma série de dados de pea e pnea que têm uma ausência de dados no ano de 2010. Como faço para corrigir essa ausência?</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106353"><span id="yui_3_16_0_ym19_1_1510346106424_102996"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106370"><span id="yui_3_16_0_ym19_1_1510346106424_102996">TrêsDuas dúvidas:</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106377"><span id="yui_3_16_0_ym19_1_1510346106424_102996"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106372"><span id="yui_3_16_0_ym19_1_1510346106424_102996">1. Como organizar a planilha visto que devo corrigir a ausência por estado para corrigir a ausência de pea e pnea para o ano de 2010 por estado?</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106374"><span id="yui_3_16_0_ym19_1_1510346106424_102996">2. Qual a técnica que me aconselham a usar?</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106376"><span id="yui_3_16_0_ym19_1_1510346106424_102996">3. E como fazê-lo com uma única rotina?<br></span></div><div id="yui_3_16_0_ym19_1_1510346106424_103044" dir="ltr"><span id="yui_3_16_0_ym19_1_1510346106424_102996">Abaixo o link da planilha</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106672"><span id="yui_3_16_0_ym19_1_1510346106424_102996"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1510346106424_106606"><span id="yui_3_16_0_ym19_1_1510346106424_102996"><a href="http://www.datafilehost.com/d/9d9001cc" class="enhancr2_9d6a8f8b-6f7d-d0a3-89dc-5ef039d77150" id="yui_3_16_0_ym19_1_1510346106424_106655">Download pea pnea 02 14.csv</a><br></span></div><div id="yui_3_16_0_ym19_1_1510346106424_106673"><br></div><div id="enhancr2_9d6a8f8b-6f7d-d0a3-89dc-5ef039d77150" class="yahoo-link-enhancr-card yahoo-link-enhancr-not-allow-cover ymail-preserve-class ymail-preserve-style" style="max-width:400px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;" data-url="http://www.datafilehost.com/d/9d9001cc" data-type="yenhancr" data-category="article" data-embed-url="" data-size="medium" dir="ltr" contenteditable="false"> <a href="http://www.datafilehost.com/d/9d9001cc" style="text-decoration:none !important; color: #000 !important" class="yahoo-enhancr-cardlink" target="_blank" rel="noreferrer" id="yui_3_16_0_ym19_1_1510346106424_106682"> <table class="card-wrapper" style="max-width:400px;" id="yui_3_16_0_ym19_1_1510346106424_106681" cellspacing="0" cellpadding="0" border="0"> <tbody id="yui_3_16_0_ym19_1_1510346106424_106680"><tr id="yui_3_16_0_ym19_1_1510346106424_106679"> <td id="yui_3_16_0_ym19_1_1510346106424_106678" width="400"> <table class="card-info" style="background:#fff;max-width:400px;border:1px solid #e0e4e9;border-bottom:3px solid #000000;" id="yui_3_16_0_ym19_1_1510346106424_106677" width="100%" cellspacing="0" cellpadding="0" border="0"> <tbody id="yui_3_16_0_ym19_1_1510346106424_106676"><tr id="yui_3_16_0_ym19_1_1510346106424_106675"> <td style="vertical-align:top;padding:16px 0 16px 12px;"> </td> <td style="vertical-align:middle;padding:16px 12px;width:99%;" id="yui_3_16_0_ym19_1_1510346106424_106674"> <h2 class="card-title" style="margin:0 0 4px 0;font-size:16px;font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;word-break:break-word;" id="yui_3_16_0_ym19_1_1510346106424_106726">Download pea pnea 02 14.csv</h2> <div class="card-description" style="font-size:11px;line-height:15px;color:#999;word-break:break-word;"></div> </td> <td class="card-share-container"></td> </tr> </tbody></table> </td> </tr> </tbody></table> </a></div><div id="yui_3_16_0_ym19_1_1510346106424_106693"><br></div><div id="yui_3_16_0_ym19_1_1510346106424_103043"><span id="yui_3_16_0_ym19_1_1510346106424_102996"></span></div><div id="yui_3_16_0_ym19_1_1510346106424_99240"> [ ]'s<br></div><div class="signature" id="yui_3_16_0_ym19_1_1510346106424_99236">Prof. Edson Lira, Me <br>Estatístico<br>Manaus-Amazonas</div></div></body></html>