How can i modify excel dataset column value(eg. age) with mean of that column value? please suggest

[Nishi_Bodake]

How can i modify excel dataset column value(eg. age) with mean of that column value? please suggest

[SASKiwi]

Please clarify your question. Have you imported an Excel sheet into a SAS dataset and want to calculate the mean age across all rows? Or are you trying to do something else?

[Nishi_Bodake]

Yes..I want to calculate mean of age and replace it with some of the value

[SASKiwi]

Assigning the mean age to another variable is preferable:

proc sql;
  create table want as
  select  *
         ,mean(age) as mean_age
  from have
  ;
quit;