topic Re: proc contents -prevent print in SAS Programming

proc contents -prevent print

Ronein — Tue, 16 May 2023 11:06:18 GMT

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;

Re: proc contents -prevent print

Quentin — Tue, 16 May 2023 11:10:44 GMT

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 ;

Re: proc contents -prevent print

ballardw — Tue, 16 May 2023 15:22:45 GMT

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.