topic Re: How to index datasets in Mathematical Optimization, Discrete-Event Simulation, and OR

How to index datasets

noobs — Thu, 11 Jul 2013 11:50:41 GMT

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

Re: How to index datasets

MMMIIIIKKKKEEEE — Thu, 11 Jul 2013 13:32:28 GMT

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)

Re: How to index datasets

noobs — Fri, 12 Jul 2013 23:42:42 GMT

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