Dear Statalisters,

I have 1696 variables for which there daily values available for a period of 16 years. For instance, I have 252 values for first year for first variable, 252 values for second year for first variable and so on. I want to calculate the year-wise standard deviation of each variable and store it one by one separately for all 1696 variables. I have done this for one variable by using the following command.

bysort Year: egen SDVariable1 = sd( Variable1 )

A new variable gets created which has the standard deviation for each year for Variable1. Now, I would like to repeat this process for all 1696 variables so that 1696 new variables are created which contain standard deviation for all years for a particular variable.

Please guide me with a way to create new variables repeatedly

Thanks!