topic SAS EG - sort output data in alphabetic order in SAS Enterprise Guide

SAS EG - sort output data in alphabetic order

Suzy_Cat — Thu, 03 Oct 2019 04:41:47 GMT

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

Re: SAS EG - sort output data in alphabetic order

Patrick — Thu, 03 Oct 2019 09:08:57 GMT

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.

Re: SAS EG - sort output data in alphabetic order

Suzy_Cat — Thu, 03 Oct 2019 20:56:09 GMT

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.

Re: SAS EG - sort output data in alphabetic order

TomKari — Thu, 03 Oct 2019 20:59:33 GMT

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

Re: SAS EG - sort output data in alphabetic order

Suzy_Cat — Thu, 03 Oct 2019 21:04:34 GMT

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