Hi Tom,

Refering to http://listserv.uga.edu/cgi-bin/wa?A2=ind9908C&L=sas-l&P=R15027.

You can see that FROM CONNECTION TO xxx () sends an SQL text over to the SQL Server and then *returns* a table.

The EXECUTE () by xxx sends an SQL text over to the SQL Server and *does not return a table*.

You can see in the archived post, a sample of CREATE TABLE..., you just need to look at the SQL Server syntax for CREATE INDEX and use the EXECUTE () by xxx to run the command on the SQL Server.

Hope this is helpful.

Mark Terjeson Senior Programmer Analyst, IM&R Russell Investments

Russell Investments Global Leaders in Multi-Manager Investing

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Green4Ever Sent: Thursday, January 31, 2008 7:18 AM To: SAS-L@LISTSERV.UGA.EDU Subject: How to create index in Access database out of SAS?

Hello,

First I do an export of my SAS-dataset to an Access Database, then I want to create an index on a field in my Access Database. Can I do this with SAS and how?

Thanks,

Tom