BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Ronein
Meteorite | Level 14

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;
1 ACCEPTED SOLUTION

Accepted Solutions
Quentin
Super User

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 ;

 

BASUG is hosting free webinars ! Next up: Art Carpenter on February 28 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

View solution in original post

2 REPLIES 2
Quentin
Super User

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 ;

 

BASUG is hosting free webinars ! Next up: Art Carpenter on February 28 at noon ET. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.
ballardw
Super User

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.

sas-innovate-2024.png

 

Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.

 

Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer. 

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 207 views
  • 5 likes
  • 3 in conversation