replace the missing values with mean in unbalanced panel data

[srikanthyadav44]

I have an unbalanced panel data with missing values.

I want to replace the missing values with mean of the time series observations of  the concerned cross-sectional unit.

How to perform this function in SAS.

Thanks in advance.

[PeterClemmensen]

Can you show us some data?

[srikanthyadav44]

Dear Mr. Draycut. thanks for your prompt response.

the format of my data is as follows 

Company_Name	year	Total_remuneration	Capex
20 Microns Ltd.	2014	3916000	160
20 Microns Ltd.	2015	3916000
20 Microns Ltd.	2016	4230000	60.9
20 Microns Ltd.	2017	4961387	51.4
20 Microns Ltd.	2018	4932459	162.3
3I Infotech Ltd.	2012		6866.4
3I Infotech Ltd.	2013	13360000	9267.5
3I Infotech Ltd.	2014	23480000	821
3I Infotech Ltd.	2015	17780000
3I Infotech Ltd.	2017	27000000	11.2
3I Infotech Ltd.	2018	19303045	13.9
63 Moons Technologies Ltd.	2015	38726562	-2.5
63 Moons Technologies Ltd.	2016		22.8
63 Moons Technologies Ltd.	2017	3902000	40
63 Moons Technologies Ltd.	2018	17257000	72.7
A 2 Z Infra Engg. Ltd.	2015	3639600
A 2 Z Infra Engg. Ltd.	2016	3033350	-53.6
A 2 Z Infra Engg. Ltd.	2017	10641600	-21.6
A 2 Z Infra Engg. Ltd.	2018		-9.6
A B G Shipyard Ltd.	2014	2755645	-405.3
A B G Shipyard Ltd.	2015	13449000	-296.2

please help in writing a SAS code to fill the missing values with the mean of the observations of  respective company

thanks in advance  

[Reeza]

PROC STDIZE.

---

@srikanthyadav44 wrote:

I have an unbalanced panel data with missing values.

I want to replace the missing values with mean of the time series observations of  the concerned cross-sectional unit.

How to perform this function in SAS.

Thanks in advance.

---

[Rick_SAS]

read the article "Mean imputation in SAS," which contains an example. Also, read the article "3 problems with mean imputation"

to make yourself aware of how mean imputation affects subsequent analyses.