How to index datasets

[noobs]

Hello MO/OR community,

I intend to compress data set and while examining PROC CONTENTS, I found following additional information:

Protection

Data Set Type

Indexes 0

Compressed NO

Sorted NO

If I were to modify Compressed to YES, how should I proceed?

In general, what are options for Protection, Data Set Type, Indexes, Sorted and how to modify these? Are there some macros to address this? Is it user-level grant

Thankfully,

Dhanashree Gadkari

[MMMIIIIKKKKEEEE]

Dhanashree,

The options for protection can be found in the passwords section of my paper:  PROC DATASETS; the Swiss Army Knife of SAS Procedures, http://support.sas.com/resources/papers/proceedings11/274-2011.pdf .

Data set type is usually DATA, VIEW, or INDEX.  However, I understand that there are additional data types associated with PROC CORR, but I have never used it and cannot comment on it further.

As far as Indexes go, see my paper:  The Basics of Using SAS Indexes, http://www2.sas.com/proceedings/sugi30/247-30.pdf to get this information for free.  Or, if you are really interested, consider my SAS Press book:  The Complete Guide to SAS Indexes, https://support.sas.com/publishing/authors/raithel.html which will cost you a dollar or "two".

Finally, SORTED is set by SAS when the data are sorted or when you assert a sort on the data set via PROC DATASETS.  See first paper mentioned for that later point.

Best of luck in all your SAS endeavors!

----MMMMIIIIKKKKEEE

(aka Michael A. Raithel)

[noobs]

Michael Raithel,

Those reads provided answers to my attempt of bridging between SAS and SQL. Very well then!

Your wishes are much needed this moment.

Dhanashree