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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.