proc contents -prevent print

[Ronein]

Hello

What is the way to prevent print of proc contents ?

I just want to create data set with the information .

proc contents data=sashelp.cars;
ods output variables=variables;
run;

[Quentin · Accepted solution]

PROC CONTENTS has an OUTPUT option, which can be used simultaneously with the NOPRINT option:

proc contents data=sashelp.cars out=variables noprint;
run;                           

If you use ODS OUTPUT to write an output dataset, you can't use the NOPRINT option.  Instead, you can close the output destinations prior to calling PROC CONTENTS, and open them after, e.g.:

ods _all_ close ;
ods output variables=variables;
proc contents data=sashelp.cars ;
run;
ods output close ;
ods listing ;

[ballardw]

Or

proc sql;
   create table variables as
   select *
   from dictionary.columns
   when libname='SASHELP' and memname='CARS'
  ;
quit;

The dictionary tables, or the SASHELP views, such as VCOLUMN have the details of all the data sets currently accessible by SAS. The Libname and Memname (name of set) are stored in upper case letters.