BookmarkSubscribeRSS Feed
noobs
Calcite | Level 5

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

2 REPLIES 2
MMMIIIIKKKKEEEE
Obsidian | Level 7

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)

Best of luck in all your SAS endeavors!

----MMMMIIIIKKKKEEEE
(aka Michael A. Raithel)
Amazon Author's Page: http://www.amazon.com/Michael-A.-Raithel/e/B001K8GG90/ref=ntt_dp_epwbk_0
noobs
Calcite | Level 5

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 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Multiple Linear Regression in SAS

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.

Discussion stats
  • 2 replies
  • 819 views
  • 0 likes
  • 2 in conversation