SAS author's tip: Creating a composite index for a new SAS table


The Complete Guide to SAS IndexesThis week's tip is from Michael Raithel and his classic book The Complete Guide to SAS Indexes. Michael has a wealth of SAS experience and is a frequent and sought-out speaker at SAS Global Forum and regional user group conferences. If you get the opportunity to hear him speak, don't pass it up!

The following excerpt is from SAS Press author Michael Raithel and his book "The Complete Guide to SAS Indexes". Copyright © 2006, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. (please note that results may vary depending on your version of SAS software)


Learn more about Michael and his work by visiting his author page. View a previously featured excerpt from The Complete Guide to SAS Indexes on this blog: Preserving indexes while using the COPY procedure;


About Author

Shelly Goodin

Social Media Specialist, SAS Publications

Shelly Goodin is SAS Publications' social media marketer and the editor of "SAS Publishing News". She’s worked in the publishing industry for over thirteen years, including seven years at SAS, and enjoys creating opportunities for fans of SAS and JMP software to get to know SAS Publications' many offerings and authors.

Related Posts


  1. Michael A Raithel on


    Good point. One can create an index at the time a SAS data set is created either in the DATA step or with PROC SQL. PROC SQL and PROC DATASETS are the tools for retrofitting existing SAS data sets with indexes.

  2. I just want to mention that if an individual wants to create a data set and an index at the same time, it is possible to use data step with an index option. "proc sql" is useful when we want to create an index on an existing data set.

Leave A Reply

Back to Top