Need a hand to locate your variables in an entire library

The ability to quickly identify the location of a variable in an entire library is critical during table, figure and listing (TFL) development, especially, when there is only limited information available for some of the variables. For example, sometimes, there may only be a partial variable name available, or perhaps you may only know one of the values for a variable. It is really time consuming to manually search for the expected variable in an entire library. Instead of opening each dataset and manually searching for the expected variables, the macro presented in this paper is a SAS® macro program designed to identify the location of a variable in a time-efficient and user-friendly way. It can automatically search all variables in a library regardless of the dataset structure and variable names. The macro is designed to obtain the location of a variable from one of following conditions: 1) A known partial or full variable name; 2) A known partial or full variable label; 3) A known partial or full variable value. The output of this macro will provide the dataset name and the full variable name of the variables searched. Use of this macro will significantly shorten search time, and help to increase TFL production efficiency.