Please help with population data structuring?

[SP01]

Hello All,

I have dataset A 

datalines  age race sex county   population 

                 1     W     F     Adams   139

Here population 139 is the aggregate of that age, sex, race, and county.

What I want to do is replicate that above combination to 138 rows to reflect as row level data. Any help is really appreciated?

Thank you!

[Kurt_Bremser]

Do you want to split this observation into 138 observations which sum up to 139?

[SP01]

Yes, that is right. Thank you! Any help would be great.

[Kurt_Bremser]

So you want 137 observations with a value of 1 and one observation with a value of 2?

[SP01]

So, it is actually 138 observations with that combination of age, race, sex etc. I have sum for each combination in my data already. I need to expand or split those into rows based on that number. Thank you!

[Kurt_Bremser · Accepted solution]

A simple DO loop:

data want;
set have;
do i = 1 to population;
  population = 1;
  output;
end;
drop i;
run;

[SP01]

Thank you, Sir! This worked. Much appreciated.