BookmarkSubscribeRSS Feed
Srigyan
Quartz | Level 8

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?

7 REPLIES 7
soham_sas
Quartz | Level 8

do it like this 

 

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

Srigyan
Quartz | Level 8

This is giving me a blank value.

 

memnamenobs
Table 1.
Table 2.
Table 3.
Table 4.
soham_sas
Quartz | Level 8
please share your log details , the code is working for me
andreas_lds
Jade | Level 19

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

Srigyan
Quartz | Level 8

Value is (.)  for metadata tables.

andreas_lds
Jade | Level 19

@Srigyan wrote:

Value is (.)  for metadata tables.


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

LinusH
Tourmaline | Level 20
No of records is not available in SAS for external data sources. You need to query Oracle for that information.
Data never sleeps

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 1877 views
  • 0 likes
  • 4 in conversation