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;
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 ;
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 ;
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.