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;
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;
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;
Awesome Reeza. Thank you a lot for such an easy solution. I have changed the accepted solution to your reply.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.