I was given a frequency dataset and I would like to expand the rows based on n to better analyze the data. The way the data is collected is by frequency of specific disaggregate as opposed to one observation at a time. How would I go about duplicate a row based on the number of frequency? Would a DO loop work in this sense? Here is an example of what is given: Obs Sex No/Yes Frequency 1 Female Yes 5 2 Male No 3 3 Male Yes 2 4 Female Yes 3 And I would like the data to look like this based on 'frequency' and will drop the 'frequency' later Obs Sex No/Yes Frequency 1 Female Yes 5 2 Female Yes 5 3 Female Yes 5 4 Female Yes 5 5 Female Yes 5 6 Male No 3 7 Male No 3 8 Male No 3 ... Thanks for your help.
... View more