07-16-2015 03:24 AM
I have a dataset with 10 variables and 600k records. It is the end result of a number of preceding processes, and one of the effects of these processes is that the dataset is ordered by age. Is there a simple sas procedure which can be written to get rid of the sorting ? I don't want to do say 3 proc surveyselects and then put the datasets together again
07-16-2015 04:17 AM
Just for laughs, try proc whisk?
For the above, you could do in one step:
create table want as select * from sashelp.cars order by ranuni(0);
Also, I would ask why do you want to scramble the dataset. Generally ordered datasets would be easier to use, maybe you just need to change the order or retain original ordering:
Then later on sort by _n_ to get it to the original sort.
07-16-2015 09:02 AM
Also great thanks RW 9 ! I want to scramble the datasets so that the customers are not called in any predefined sequence or bias which is built in via the preceding datasteps
Need further help from the community? Please ask a new question.