Date:         Thu, 14 Aug 2008 10:38:21 -0400
Reply-To:     Jeff <zhujp98@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jeff <zhujp98@GMAIL.COM>
Subject:      how to check if index exist?
Content-Type: text/plain; charset=ISO-8859-1

 Code:
proc *sql*;

create unique index inx_dz_ind on Mdata.PM_FLAGS_MULTIPLE (elig_id,
model_time_ind);
quit;



Error

2695 create unique index inx_dz_ind on Mdata.PM_FLAGS_MULTIPLE (elig_id,
model_time_ind);

ERROR: An index named indx with the same definition already exists for file

MDATA.PM_FLAGS_MULTIPLE.DATA.



This is a large project invovling lots of code.

Is there a ways I can check if index already exist?

if the index already there I will do noting, otherwise create the index.

How can I do that?

Thanks.



Jeff