It is difficult to obtain comprehensive table metadata at the moment.
The variable metadata is all in proc contents out=, which is easy enough to access
The data set metadata though is scattered. Most of it is in SASHELP.VTABLE (or DICTIONARY.TABLES), but this is slow and incomplete.
If you want the data set's Engine or the Number of indexes, this is obtained by running proc contents with ods output atttributes.
If you want
First Data Page
Max Obs per Page
Obs in First Data Page
Index File Page Size
Number of Index File Pages
Number of Data Set Repairs
then you need to run proc contents with ods output enginehost.
I'd like a centralised, easy to query, comprehensive, single metadata repository.
And the situation is much worse for SPDE metadata, so this should urgently be added at the same time.
And I think I recall that "size occupied on disk" is also available yet somewhere else.
The V tables you refer to are actually views, so there is no reason why you couldn't copy that code, and modify it in the autoexec.sas. I do agree though a centralised metadata setup would be useful which is why I add a vote here (why did you not vote for your own idea?). The one thing I would just note however is that the metadata could get quite large.
Not any larger than what we have, I am not after more information, but all in one place.
good idea, so, how do think we should do it?
I don't want to be too directive but proc contents out= seems the perfect vehicle. Sashelp.Vtable is too slow. Ods output needs noprint off. Why the downvote?
Please be more explicit and directive, give a suggestion. I haven't been convinced that a PROC CONTENTS solution is better that the SASHELP solution.
1- Have libnames with thousands of tables | large SPDE tables | RDBMS access views and you'll see why proc contents is better: the SASHELP views will take for ever to be accessed.
2- The SASHELP views are incomplete anyway. All sources are incomplete at the moment, hence my suggestion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.