DATA Step, Macro, Functions and more

How to quickly find the dataset

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

How to quickly find the dataset

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)

 

Capture.PNG


Accepted Solutions
Solution
‎02-12-2018 07:51 PM
Super User
Posts: 13,066

Re: How to quickly find the dataset

Posted in reply to Jiawenabby8

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.

View solution in original post


All Replies
Super User
Posts: 22,857

Re: How to quickly find the dataset

Posted in reply to Jiawenabby8
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
Occasional Contributor
Posts: 5

Re: How to quickly find the dataset

Thanks, it's very helpful.

Solution
‎02-12-2018 07:51 PM
Super User
Posts: 13,066

Re: How to quickly find the dataset

Posted in reply to Jiawenabby8

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.

Occasional Contributor
Posts: 5

Re: How to quickly find the dataset

Posted in reply to Jiawenabby8
Thank you so much, very informative!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 184 views
  • 5 likes
  • 3 in conversation