SPDSVERB Macro Variable

Specifies that PROC CONTENTS output include details about compressed blocks, data partition size, and indexes.

Valid in:	SPD Server
Default:	NO
Restriction:	Assignments for macro variables with character input (for example, YES \| NO \| BINARY arguments) must be entered in uppercase (capitalized).
Interaction:	Corresponding table option is VERBOSE=.

Syntax

Required Arguments

Example

Syntax

SPDSVERB=YES | NO

Required Arguments

YES

requests detail information about compressed blocks, data partition size, and indexes.

NO

suppresses detail information about compressed blocks, data partition size, and indexes.

Example

You need information about associated indexes for the server table MyLib.Supply. Configure the server for verbose details at the start of your session so that you can see index details. Submit the SPDSVERB macro variable as a line in your autoexec.sas file:

%let SPDSVERB=YES;

Submit a PROC CONTENTS request for the MyLib.Supply table:

proc contents data=mylib.supply;
run;

SPDSVERB Macro Variable

Syntax

Required Arguments

YES

NO

Example

See Also