- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi the community, I find this view very helful in information catalog. I would like to have a table. What is the script to do this. My librairie is 'OA'
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
data want;
set sashelp.vtable;
where libname = "OA";
run;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Yeah !! perfect. Is it normal that the files ize is always 0. It's interesting to know the size in MO or Go. Thanks a lot
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If the library has SAS datasets in it, you should see the size. But it looks like the library points to CAS tables? It's possible the sashelp catalog won't know the size of the table. That often happens with libraries that point to relational databases as well. If you need to get the size of a CAS table, you might want to look at CAS-specific methods, see e.g. this thread: https://communities.sas.com/t5/SAS-Viya/How-to-get-the-size-of-a-table-in-CAS/td-p/760880 .
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot, can you confirm please. The description label is equal to memlabel in the sashelp.vtable