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?
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.
Ready to level-up your skills? Choose your own adventure.