Date: Sat, 13 Jan 2001 10:28:35 -0500
Reply-To: Richard DeVenezia <radevenz@IX.NETCOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Richard DeVenezia <radevenz@IX.NETCOM.COM>
Organization: MindSpring Enterprises
Subject: Re: Retrieving Index information by SCL
Current index names, associated columns and properties such as uniqueness
and nullness can be obtained from SASHELP.VINDEX.
Richard DeVenezia - SAS Macros and AF Tools
"Walter Smetsers" <Walter.Smetsers@eomdata.nl> wrote in message
> Hi y'all,
> I have a question about retrieving information about
> indexes within SCL.
> * I have a dataset with password-protection (PW=...).
> * I want to register all the indexes which are available
> for the dataset.
> * I don't have the ability to use SUBMIT blocks.
> Solution uptill now:
> * I can retrieve information about a single/composite index
> by using IVARLIST. The missing part with this solution is
> that IVARLIST needs a indexname => I don't know which
> indexes are used on the dataset, so no information possible.
> Any help on this matter would be appriciated.
> Walter Smetsers
> E.O.M Data - Hilversum
> The Netherlands