The requirement is: Use PROC CONTENTS to view the descriptor portion of each of the three data sets.
Include only the first table from each of the PROC CONTENTS output (the one with the
number of observations and variables) and don’t include the other two tables (engine data
and variable attributes) in the Report
Does anyone know what I need to add on proc contents and let it only shows the first table?
Use ods trace on to find the names of the tables. Then use ods select to select the table(s) of interest.
ods trace on; proc contents data=sashelp.iris; ods select attributes; run;
Use ods trace on to find the names of the tables. Then use ods select to select the table(s) of interest.
ods trace on; proc contents data=sashelp.iris; ods select attributes; run;
Thank you it works.
Of course you could just skip the PROC CONTENTS altogether and query the metadata yourself.
proc print data=sashelp.vtable ;
where libname='WORK';
run;
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.