SAS EG - sort output data in alphabetic order

[Suzy_Cat]

Hi there

I wondered if anyone knows how to sort and veiw all outputs datasets in SAS EG? If the outputs are sorted in alphabetic order, it will be much easier to find the data output to review result.

Any suggestions?

Thanks

Sue

[Patrick]

You could use the Filter and Sort task to order your data in the way you like it.

The task is also available directly from the opened data grid.

[Suzy_Cat]

Thanks Patrick, but that is not what I was asking.

in the Options setting, Maximum number of output data sets is set to 50, that means there will be loads of datasets can be viewed from the drop down list. My question is how to set those files sorted by their name other than random order (I guess they were listed by the time they were created or last updated?). If they are sorted by name, it is easier to find the one when needed.

Thanks again for looking into the solutions.

[TomKari · Accepted solution]

Two quick comments:

In my experience, they are sorted by the order in which they're created. BUT, if you run multiple times, and change the code to add or not create datasets, it will generally sort of keep the datasets that were created on the last run ahead of the datasets that are new to this run. One solution is to delete the datasets from your workspace before running code...then you'll get a nice set in the correct sequence.

Once I've tested code, it's rare that I want to see all of the datasets that I've created. So as a last step in the code I delete all of the datasets that I don't need...then the list contains only the remaining datasets.

Tom

[Suzy_Cat]

Thought so. Yeah that was what my plan - to delete all previously created redundent datasets. Thanks a lot Tom!