topic Re: How to quickly find the dataset in SAS Programming

How to quickly find the dataset

Jiawenabby8 — Mon, 12 Feb 2018 22:47:33 GMT

How do I quickly find the specific dataset in a library, since I have hundreds of datasets in that library.

for example:

I want to open one dataset (named 'test') from the 'lib' library. Instead of every time I have to scroll down and look for the dataset, is there any search options or shortcut that I can use to quickly open the dataset?

I am using 9.3 (TS1M2)

Re: How to quickly find the dataset

Reeza — Mon, 12 Feb 2018 22:49:25 GMT

Change it to list view for starts and then you can sort alphabetically, or by size.

Click in the work library, select View (menu)>Details

Re: How to quickly find the dataset

Jiawenabby8 — Mon, 12 Feb 2018 22:55:28 GMT

Thanks, it's very helpful.

Re: How to quickly find the dataset

ballardw — Tue, 13 Feb 2018 00:15:53 GMT

If you know the name of the data set and the library, such as lib.test in your example, type in the command box (the one with the check marke next to it in your posted image)

vt lib.test

VT is the viewtable command that is run when you click on a dataset icon.

If you want to be able to sort or modify the data use

vt lib.text openmode=edit

to make changes to the data set.

And if the set you want to see by any chance is the last one created

vt _last_

and you don't even have to remember the spelling.

If you find the vt _last_ helpful you might add it to a keys menu and it becomes a single key command.

Re: How to quickly find the dataset

Jiawenabby8 — Tue, 13 Feb 2018 00:53:39 GMT

Thank you so much, very informative!