topic Re: Number of records in for each dataset available in a metadata sas library in SAS Programming

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

Srigyan — Fri, 06 Jul 2018 11:03:29 GMT

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?

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

soham_sas — Fri, 06 Jul 2018 11:18:45 GMT

do it like this

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

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

andreas_lds — Fri, 06 Jul 2018 11:22:09 GMT

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

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

Srigyan — Tue, 10 Jul 2018 12:40:26 GMT

This is giving me a blank value.

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

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

Srigyan — Tue, 10 Jul 2018 12:47:44 GMT

Value is (.) for metadata tables.

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

soham_sas — Tue, 10 Jul 2018 15:08:41 GMT

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

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

andreas_lds — Tue, 10 Jul 2018 15:45:48 GMT

@Srigyan wrote:

Value is (.) for metadata tables.

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

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

LinusH — Tue, 10 Jul 2018 22:17:24 GMT

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