BookmarkSubscribeRSS Feed
Tobiasp94
Calcite | Level 5

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.

 

3 REPLIES 3
andreas_lds
Jade | Level 19

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.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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;

 

 

 

Patrick
Opal | Level 21

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;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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!

Register now

Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1352 views
  • 0 likes
  • 4 in conversation