Why Proc contents does not show the number of observations in my dataset?

[Tom]

If you run PROC CONTENTS on tables/views that are in a foreign database (Oracle, Teradata, etc) then it will not report the number of observations.  It has nothing to do with the size of the table.  When SAS writes a SAS dataset it stores the number of observations where PROC CONTENTS can retrieve it without counting all of the rows.  It cannot do that for external databases.

[Mirisage]

Hi Tom,
Thank you for your nice clarification .

Hi Scott_Mitchell,

Thank you for your ontribution.

Regards

Mirisage

[Tom]

What do you mean by a 'warehouse'?  If it is in some non-SAS database management system (oracle, teradata, etc) then SAS cannot know the number of observations without asking the database.