How to call dataset automatically without calling the lib ?

Phil_NZ — Fri, 05 Mar 2021 22:47:35 GMT

Hi SAS Users,

I want to work efficiently by using SAS EG, and one function I am really into is the automatically suggestion about function and dataset.

However, regarding dataset, they normally suggest that I need to type the library first then SAS EG will suggest me the dataset inside this library.

I am wondering that is there any way when I type "data" statement, SAS EG will suggest all the datasets that I can choose and "enter" quickly rather than I must type the lib (for example: WORK) first then get the dataset hint from SAS EG. It makes my dataset name looks longer and the lib name plays no role here.

I am not lazy, but sometimes the library name is just redundant, and I want to optimize and simplify my coding progress as well.

Warmest regards.

P/S: Even when I call a dataset in set statement., I also need to call the library first and then SAS EG will suggest me the datasets inside. I am not greedy, just want to know if there is any way to shorten the coding progress.

Re: How to call dataset automatically without calling the lib ?

ballardw — Fri, 05 Mar 2021 23:23:07 GMT

@Phil_NZ wrote:

Hi SAS Users,

I want to work efficiently by using SAS EG, and one function I am really into is the automatically suggestion about function and dataset.

However, regarding dataset, they normally suggest that I need to type the library first then SAS EG will suggest me the dataset inside this library.

I am wondering that is there any way when I type "data" statement, SAS EG will suggest all the datasets that I can choose and "enter" quickly rather than I must type the lib (for example: WORK) first then get the dataset hint from SAS EG. It makes my dataset name looks longer and the lib name plays no role here.

I am not lazy, but sometimes the library name is just redundant, and I want to optimize and simplify my coding progress as well.

Warmest regards.

P/S: Even when I call a dataset in set statement., I also need to call the library first and then SAS EG will suggest me the datasets inside. I am not greedy, just want to know if there is any way to shorten the coding progress.

The process is called "typing" if you are coding.

I suggest that you run this code in your session:

proc sql;
   select libname, memname
   from dictionary.tables
   ;
quit;

That will list all the data sets in all the libraries that would be presented if you had your wish for a "suggestion" based on just "data".

I am guessing that you will get somewhere around 40+ just in the SASHELP library. If you have enough modules installed may be more. SAS Graph for instance will add a couple of map related libraries with a couple hundred data sets in each (one map for most countries in the world, often a second with major features like cities, some with subdivisions like states or counties; continents ).

My actual work installation has 15 permanent libraries and anywhere from 1 to 10 temporary libraries depending on what I am working on that day. That code listing data sets runs to 1000's of data sets. Some of temporary libraries are creating/modifying subsets of the permanent data sets and often share some of the same names. I really wouldn't want to just grab the first data set of the name.

If you routinely use one library a lot more than others I suggest naming it so it appears first in the selection list.

Or perhaps set a couple of editor abbreviations for commonly used libraries.

topic How to call dataset automatically without calling the lib ? in SAS Programming

How to call dataset automatically without calling the lib ?

Re: How to call dataset automatically without calling the lib ?