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.
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).
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).
Thanks!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.