Hi guys,
If I have 100 numeric variables and I'd like to calculate the average while creating a new variable Mean, is there a simple statement that I can use in the data step instead of typing the variable names one by one and then calculate the average?
Thank you.
If I understand it correctly, you are trying to mean across the variables. May be this can generate the desired output.
data want;
set have;
array list{*} _numeric_;
mean=mean(of list{*});
run;
If I understand it correctly, you are trying to mean across the variables. May be this can generate the desired output.
data want;
set have;
array list{*} _numeric_;
mean=mean(of list{*});
run;
Look into SAS Variable Lists
Functions such as mean can accept variable lists as arguments. For example z = mean( of a--f, of x:); will compute the mean of variables a throuhg f in your variable list and of all variables with names starting with x. The variable list notation can save you a lot of typing and make your code more general.
PG
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.