will not set the validated flag in the data set's metadata as seen here:
One must recreate the table using for example proc sort to set this flag. This is hugely wasteful.
The following option would ask SAS to check the sort order as the data is written, in order to avoid this waste:
data T(sortedby=X validatesort);
Good idea. Would also be useful when importing text file data that is supposed to be sorted.
But then, you also need some way to take action if the validation fails. An automatic macro variable wouldn't be a good idea since many datasets may be produced by a single data step. Maybe VALIDATESORT=WARNING, VALIDATESORT=ERROR.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.