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?
do it like this
proc sql;
create table table_name as select memname,nobs from dictionary.tables
where libname='/*your library name*/';
quit;
This is giving me a blank value.
memname | nobs |
Table 1 | . |
Table 2 | . |
Table 3 | . |
Table 4 | . |
Have a look at sashelp.vtable, the view contains metadata of all datasets in assigned libraries.
Value is (.) for metadata tables.
@Srigyan wrote:
Value is (.) for metadata tables.
For all metadata-tables or only those using tables in oracle?
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.