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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.