I have uploaded a dataset with multiple variables into SAS Studio. These variables varies across time.
For instance i need to create one variable population instead of 7 variables:
Population <- Population_2010 + Population_2011 + ....
Hope someone can help.
It is recommend to avoid data in variable-names. Having one variable with the year and another with the value allows easier usage of the data. If you have to create a dataset with those year-variables you need to post a data-step with datalines statement showing the data you have. This post explains how to transform data into a data-step.
Note I am assuming your data here:
data have;
country="UK";
population_2010=10;
population_2011=20;
output;
country="US";
population_2010=15;
population_2011=25;
output;
run;
proc transpose data=have out=want;
by country;
var population_:;
run;
Here a data step option to also populate a Year variable.
data have;
country="UK";
population_2010=10;
population_2011=20;
output;
country="US";
population_2010=15;
population_2011=25;
output;
run;
data want(drop=_: population_:);
set have;
length year $4 pop_count 8;
array _pop {*} population_:;
do _i=1 to dim(_pop);
year=scan(vname(_pop[_i]),2,'_');
pop_count=_pop[_i];
output;
end;
run;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Get started using SAS Studio to write, run and debug your SAS programs.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.