topic Re: How can i modify excel dataset column value(eg. age) with mean of that column value? please sug in New SAS User

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

Nishi_Bodake — Sat, 22 Feb 2020 18:26:47 GMT

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

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

SASKiwi — Sat, 22 Feb 2020 22:14:43 GMT

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?

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

Nishi_Bodake — Sun, 23 Feb 2020 12:40:06 GMT

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

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

SASKiwi — Sun, 23 Feb 2020 19:04:38 GMT

Assigning the mean age to another variable is preferable:

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