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
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)
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.