I want to create a pseudo random data set from existing data. Basically, I have a primary data set (call it Alpha) and I want to generate a new dataset (Beta) with a random selection of lines from Alpha. The logic of the process is something like this:
1. Open Alpha.
2. Generate a random number variable in Alpha.
3. Select one line of data (row) from Alpha based on the random numbers.
4. Append this random line of data to Beta.
5. Repeat 1-4 in a loop for X repetitions to create Beta with X lines. (Random draw with possibility of repeated draws)
Is there a quick way to write a macro or proc sql to do this?