topic Expand a dataset by a specific amount in SAS Programming

Expand a dataset by a specific amount

bsam17 — Wed, 20 May 2015 20:43:27 GMT

Hi,

This may be a bit of a complex task but I was wondering if there's a solution for the following:

I have a dataset that has a "quantity" variable. I would like to expand each observation in this dataset by its quantity. For example, if row 1 has a quantity = 10, I would like to duplicate this row 10 times, and so forth. Can anyone suggest an efficient method for doing so?

Thanks in advance.

Re: Expand a dataset by a specific amount

Astounding — Thu, 21 May 2015 12:29:59 GMT

This should do it:

data want;

set have;

do _i_=1 to quantity;

output;

end;

drop _i_;

run;

You might also want to consider what should happen for unusual values for QUANTITY (negative numbers, fractional values, missing values).

Re: Expand a dataset by a specific amount

bsam17 — Fri, 05 Jun 2015 17:03:35 GMT

Thanks!