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.
Can you show us some data?
Dear Mr. Draycut. thanks for your prompt response.
the format of my data is as follows
please help in writing a SAS code to fill the missing values with the mean of the observations of respective company
thanks in advance
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Submit your idea!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.