topic Re: proc report for all the columns in a dataset in SAS Programming

proc report for all the columns in a dataset

bhu — Thu, 28 Feb 2019 22:42:12 GMT

Assuming dataset table1 has field1, how can I use proc contents inside proc report? Or is there any way to display all the columns of the dataset without actually specifying the field names?

PROC REPORT data=table1 nowd split='\' nocenter;
COLUMN
(
proc contents data = table1 varnum short;
run;

)
by fieldname1;
TITLE1 "Comparison";
RUN;

Re: proc report for all the columns in a dataset

bhu — Thu, 28 Feb 2019 22:53:33 GMT

This helped me:

proc sql noprint;
select name into :var_list separated by " " from sashelp.vcolumn where libname="WORK" and memname="TABLE1";
quit;
PROC REPORT data=table1 nowd split='\' nocenter;
COLUMN
&var_list.;
by fieldname1;
TITLE1 "Comparison";
RUN;

Re: proc report for all the columns in a dataset

Reeza — Thu, 28 Feb 2019 23:00:08 GMT

You don't specify any, defaults are an awesome thing.

proc sort data=sashelp.class out=class;
by sex;

proc report data=class;
by sex;
run;

If you don't specify any, it defaults to all variables, similar to PROC REPORT.

@bhu wrote:

Assuming dataset table1 has field1, how can I use proc contents inside proc report? Or is there any way to display all the columns of the dataset without actually specifying the field names?

PROC REPORT data=table1 nowd split='\' nocenter;
COLUMN
(
proc contents data = table1 varnum short;
run;

)
by fieldname1;
TITLE1 "Comparison";
RUN;

Re: proc report for all the columns in a dataset

bhu — Thu, 28 Feb 2019 23:05:52 GMT

Awesome Reeza. Thank you a lot for such an easy solution. I have changed the accepted solution to your reply.