Number of records in for each dataset available in a metadata sas library

[Srigyan]

I am working with some of the tables which are basically somewhere in Oracle and SAS have the metadata library. If I want to check the number of records in all these tables in SAS. How can I do that?

[soham_sas]

do it like this 

proc sql;
create table table_name as select memname,nobs from dictionary.tables
where libname='/*your library name*/';
quit;

[Srigyan]

This is giving me a blank value.

memname	nobs
Table 1	.
Table 2	.
Table 3	.
Table 4	.

[soham_sas]

please share your log details , the code is working for me

[andreas_lds]

Have a look at sashelp.vtable, the view contains metadata of all datasets in assigned libraries.

[Srigyan]

Value is (.)  for metadata tables.

[andreas_lds]

---

@Srigyan wrote:

Value is (.)  for metadata tables.

---

For all metadata-tables or only those using tables in oracle?

[LinusH]

No of records is not available in SAS for external data sources. You need to query Oracle for that information.