Searching for word in dictionary.options

From sasCommunity

Problem: You can't remember the name of a SAS system option, but you remember part of the name.

This code will search for a word in options name, setting, or description.

%Let Word = Margin;
%*Let Word = Memory;
%Let Word = %Upcase(&Word.);
PROC SQL; select Group, OptName ,Setting ,OptDesc
          from   Dictionary.Options
          where  index(upcase(OptName),"&Word.")
             or  index(upcase(Setting),"&Word.")
             or  index(upcase(OptDesc),"&Word.");
          quit;

Next step: examine group and one option.

Proc Options group = memory;
Proc Options define value option = sortsize;
run;

Result (from Version 9.1.3 for Windows):

 Option Name        Option Setting       Option Description
 ----------------------------------------------------------------------
 BOTTOMMARGIN       0.000 IN             Bottom margin for printed
                                         output
 LEFTMARGIN         0.000 IN             Left margin for printed output
 RIGHTMARGIN        0.000 IN             Right margin for printed
                                         output
 TOPMARGIN          0.000 IN             Top margin for printed output

This is output for Memory, v9.2 for Windows.

                                 Option 
Option Group  Option Name        Setting     Option Description

SASFILES      CATCACHE           0           Number of SAS catalogs to keep in cache memory
PERFORMANCE   MEXECSIZE          65536       Maximum size for a macro to execute in memory
MACRO         MSYMTABMAX         4194304     Maximum amount of memory allocated 
                                                for the macro table
PERFORMANCE   SPDEINDEXSORTSIZE  33554432    Identifies memory to be used 
                                                for SPDE asynchronous index create or append
PERFORMANCE   SPDESORTSIZE       33554432    Memory for SPDE sort operations
MEMORY        SUMSIZE            0           Upper limit for data-dependent memory usage 
                                                during summarization
MEMORY        MAXMEMQUERY        0           Maximum amount of memory returned 
                                                when inquiring as to available space
MEMORY        MEMBLKSZ           16777216    Size of memory blocks allocated 
                                                to support MEMLIB and MEMCACHE options.
SASFILES      MEMCACHE           0           Activates use of Intel Extended 
                                                Server Memory Architecture 
                                                memory for file caching.
SASFILES      MEMLIB             NOMEMLIB    Enable use of Intel Extended Memory 
                                                Server Architecture 
                                                memory for memory based librefs. 
                                                When used on startup, 
                                                applies to the WORK library.
MEMORY        MEMMAXSZ           2147483648  Maximum amount of memory allocated 
                                                to support MEMLIB and MEMCACHE options.
MEMORY        LOADMEMSIZE        0           Suggested memory limit for loaded SAS executables
PERFORMANCE   MEMSIZE            1892655360  Specifies the limit on the total amount of memory 
                                                to be used by the SAS System
MEMORY        REALMEMSIZE        0           Limit on the total amount of real memory 
                                                to be used by the SAS System

You could also look at the [list of options] in the online documentation and use the web browser's search feature to look for "margin". Another possibility is to open SASHELP.VOPTION in VIEWTABLE and use the tools provided there to isolate appearances of the string "margin".

Tiny Url: http://tinyurl.com/5zwfax

--macro maven == the radical programmer 09:57, 5 May 2008 (EDT)