topic How to Show First Table only in Proc Contents in SAS Studio

How to Show First Table only in Proc Contents

ydu180 — Sun, 09 Jul 2017 16:03:54 GMT

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?

Re: How to Show First Table only in Proc Contents

WarrenKuhfeld — Sun, 09 Jul 2017 16:16:03 GMT

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;

Re: How to Show First Table only in Proc Contents

ydu180 — Sun, 09 Jul 2017 16:57:11 GMT

Thank you it works.

Re: How to Show First Table only in Proc Contents

Tom — Sun, 09 Jul 2017 18:18:27 GMT

Of course you could just skip the PROC CONTENTS altogether and query the metadata yourself.

proc print data=sashelp.vtable ;
  where libname='WORK';
run;