This 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;
2 Comments
Dave,
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.
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.