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.
Need further help from the community? Please ask a new question.