All the information about indexes for all the members in the libraries allocated to your SAS session are available in DICTIONARY.INDEXES.

Prasad Ravi

The CONTENTS Procedure

Data Set Name: WORK.INDEXES Observations: 63 Member Type: DATA Variables: 9 Engine: V8 Indexes: 0 Created: 13:13 Tuesday, April 29, 2003 Observation Length: 136 Last Modified: 13:13 Tuesday, April 29, 2003 Deleted Observations: 0 Protection: Compressed: NO Data Set Type: Sorted: NO Label:

-----Engine/Host Dependent Information-----

Data Set Page Size: 12288 Number of Data Set Pages: 1 First Data Page: 1 Max Obs per Page: 90 Obs in First Data Page: 63 Number of Data Set Repairs: 0 File Name: d: \saswork\_TD294\indexes.sas7bdat Release Created: 8.0101M0 Host Created: WIN_NT

-----Alphabetic List of Variables and Attributes-----

# Variable Type Len Pos Label

????????????????????????????????????????????????????????????????????????????? 5 idxusage Char 9 88 Column Index Type 6 indxname Char 32 97 Index Name 7 indxpos Num 8 0 Position of Column in Concatenated Key 1 libname Char 8 8 Library Name 2 memname Char 32 16 Member Name 3 memtype Char 8 48 Member Type 4 name Char 32 56 Column Name 8 nomiss Char 3 129 Nomiss Option 9 unique Char 3 132 Unique Option

Akbar Golmirzaie <akbar@UARK.EDU> To: SAS-L@LISTSERV.UGA.EDU Sent by: "SAS(r) cc: Discussion" Subject: Macro Variable <SAS-L@LISTSERV.UGA.E DU>

04/29/2003 12:34 PM Please respond to Akbar Golmirzaie

Q? I made a data set with Index. Is there a macro variable to indicate such a data set has an index? Or is there a way to crate the macro variable? Thanks.