topic Re: Please help with population data structuring? in SAS Programming

Please help with population data structuring?

SP01 — Sun, 06 Nov 2022 18:23:32 GMT

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!

Re: Please help with population data structuring?

Kurt_Bremser — Sun, 06 Nov 2022 18:39:32 GMT

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

Re: Please help with population data structuring?

SP01 — Sun, 06 Nov 2022 18:41:19 GMT

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

Re: Please help with population data structuring?

Kurt_Bremser — Sun, 06 Nov 2022 18:51:53 GMT

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

Re: Please help with population data structuring?

SP01 — Sun, 06 Nov 2022 18:53:40 GMT

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!

Re: Please help with population data structuring?

Kurt_Bremser — Sun, 06 Nov 2022 19:07:20 GMT

A simple DO loop:

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

Re: Please help with population data structuring?

SP01 — Sun, 06 Nov 2022 19:22:07 GMT

Thank you, Sir! This worked. Much appreciated.