topic Re: replace the missing values with mean in unbalanced panel data in New SAS User https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579559#M13463 <P>Dear Mr. Draycut. thanks for your prompt response.</P><P>&nbsp;</P><P>the format of my data is as follows&nbsp;</P><TABLE><TBODY><TR><TD>Company_Name</TD><TD>year</TD><TD>Total_remuneration</TD><TD>Capex</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2014</TD><TD>3916000</TD><TD>160</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2015</TD><TD>3916000</TD><TD>&nbsp;</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2016</TD><TD>4230000</TD><TD>60.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2017</TD><TD>4961387</TD><TD>51.4</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2018</TD><TD>4932459</TD><TD>162.3</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>6866.4</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2013</TD><TD>13360000</TD><TD>9267.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2014</TD><TD>23480000</TD><TD>821</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2015</TD><TD>17780000</TD><TD>&nbsp;</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2017</TD><TD>27000000</TD><TD>11.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2018</TD><TD>19303045</TD><TD>13.9</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2015</TD><TD>38726562</TD><TD>-2.5</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2016</TD><TD>&nbsp;</TD><TD>22.8</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2017</TD><TD>3902000</TD><TD>40</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2018</TD><TD>17257000</TD><TD>72.7</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2015</TD><TD>3639600</TD><TD>&nbsp;</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2016</TD><TD>3033350</TD><TD>-53.6</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2017</TD><TD>10641600</TD><TD>-21.6</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2018</TD><TD>&nbsp;</TD><TD>-9.6</TD></TR><TR><TD>A B G Shipyard Ltd.</TD><TD>2014</TD><TD>2755645</TD><TD>-405.3</TD></TR><TR><TD>A B G Shipyard Ltd.</TD><TD>2015</TD><TD>13449000</TD><TD>-296.2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please help in writing a SAS code to fill the missing values with the mean of the observations of&nbsp; respective company</P><P>thanks in advance&nbsp;&nbsp;</P> Wed, 07 Aug 2019 05:18:54 GMT srikanthyadav44 2019-08-07T05:18:54Z replace the missing values with mean in unbalanced panel data https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579373#M13444 <P><SPAN>I have an unbalanced panel data with missing values. </SPAN></P><P><SPAN>I want to replace the missing values with mean of the time series observations of&nbsp; the concerned cross-sectional unit. </SPAN></P><P><SPAN>How to perform this function in SAS. </SPAN></P><P><SPAN>Thanks in advance. </SPAN></P> Tue, 06 Aug 2019 13:56:56 GMT https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579373#M13444 srikanthyadav44 2019-08-06T13:56:56Z Re: replace the missing values with mean in unbalanced panel data https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579377#M13445 <P>Can you show us some data?</P> Tue, 06 Aug 2019 14:04:02 GMT https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579377#M13445 PeterClemmensen 2019-08-06T14:04:02Z Re: replace the missing values with mean in unbalanced panel data https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579419#M13451 <P>PROC STDIZE.</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/280123">@srikanthyadav44</a>&nbsp;wrote:<BR /> <P><SPAN>I have an unbalanced panel data with missing values. </SPAN></P> <P><SPAN>I want to replace the missing values with mean of the time series observations of&nbsp; the concerned cross-sectional unit. </SPAN></P> <P><SPAN>How to perform this function in SAS. </SPAN></P> <P><SPAN>Thanks in advance. </SPAN></P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Tue, 06 Aug 2019 15:18:37 GMT https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579419#M13451 Reeza 2019-08-06T15:18:37Z Re: replace the missing values with mean in unbalanced panel data https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579426#M13452 <P>read the article <A href="https://blogs.sas.com/content/iml/2017/12/04/mean-imputation-sas.html" target="_self">"Mean imputation in SAS,"</A> which contains an example. Also, read the article <A href="https://blogs.sas.com/content/iml/2017/12/06/problems-mean-imputation.html" target="_self">"3 problems with mean imputation"</A></P> <P>to make yourself aware of how mean imputation affects subsequent analyses.</P> Tue, 06 Aug 2019 15:30:37 GMT https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579426#M13452 Rick_SAS 2019-08-06T15:30:37Z Re: replace the missing values with mean in unbalanced panel data https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579559#M13463 <P>Dear Mr. Draycut. thanks for your prompt response.</P><P>&nbsp;</P><P>the format of my data is as follows&nbsp;</P><TABLE><TBODY><TR><TD>Company_Name</TD><TD>year</TD><TD>Total_remuneration</TD><TD>Capex</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2014</TD><TD>3916000</TD><TD>160</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2015</TD><TD>3916000</TD><TD>&nbsp;</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2016</TD><TD>4230000</TD><TD>60.9</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2017</TD><TD>4961387</TD><TD>51.4</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2018</TD><TD>4932459</TD><TD>162.3</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2012</TD><TD>&nbsp;</TD><TD>6866.4</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2013</TD><TD>13360000</TD><TD>9267.5</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2014</TD><TD>23480000</TD><TD>821</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2015</TD><TD>17780000</TD><TD>&nbsp;</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2017</TD><TD>27000000</TD><TD>11.2</TD></TR><TR><TD>3I Infotech Ltd.</TD><TD>2018</TD><TD>19303045</TD><TD>13.9</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2015</TD><TD>38726562</TD><TD>-2.5</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2016</TD><TD>&nbsp;</TD><TD>22.8</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2017</TD><TD>3902000</TD><TD>40</TD></TR><TR><TD>63 Moons Technologies Ltd.</TD><TD>2018</TD><TD>17257000</TD><TD>72.7</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2015</TD><TD>3639600</TD><TD>&nbsp;</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2016</TD><TD>3033350</TD><TD>-53.6</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2017</TD><TD>10641600</TD><TD>-21.6</TD></TR><TR><TD>A 2 Z Infra Engg. Ltd.</TD><TD>2018</TD><TD>&nbsp;</TD><TD>-9.6</TD></TR><TR><TD>A B G Shipyard Ltd.</TD><TD>2014</TD><TD>2755645</TD><TD>-405.3</TD></TR><TR><TD>A B G Shipyard Ltd.</TD><TD>2015</TD><TD>13449000</TD><TD>-296.2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>please help in writing a SAS code to fill the missing values with the mean of the observations of&nbsp; respective company</P><P>thanks in advance&nbsp;&nbsp;</P> Wed, 07 Aug 2019 05:18:54 GMT https://communities.sas.com/t5/New-SAS-User/replace-the-missing-values-with-mean-in-unbalanced-panel-data/m-p/579559#M13463 srikanthyadav44 2019-08-07T05:18:54Z