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'
Try this:
data want;
set sashelp.vtable;
where libname = "OA";
run;
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
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 .
Thanks a lot, can you confirm please. The description label is equal to memlabel in the sashelp.vtable
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.