topic Re: How to put outputs of proc reports or proc tabulate and proc report side by side in SAS Programming

How to put outputs of proc reports or proc tabulate and proc report side by side

Garik — Tue, 11 Jul 2017 07:22:15 GMT

Hi.

I have such problem. I create several reports via proc reports and proc tabulate, but they are presented under one another, but I have free space on my scree I would like to put them side by side.

I use SAS Enterprise Guide



title "Sold Items" ;
proc report data=without_colors;
where Date eq '30Jun17'd;	
column Area N_Item_Name Sale_Category;
	define Area/ group width=6;
	define N_Item_Name / Across format=$mdclass. width=6; 
	define Sale_Category / Across width=6;
	
run;


title "Remaining Mobile Devices in the Warehouses" ;
proc report data=r_675_without_colors;
	where New_Date eq '30Jun17'd;	
    column Area N_Item_Name;

    define Area   / group width=6;
	define N_Item_Name / Across format=$mdclass. width=6; 
run;

Re: How to put outputs of proc reports or proc tabulate and proc report side by side

andreas_lds — Tue, 11 Jul 2017 07:37:23 GMT

Please attach a screenshot as image, not as office document.

You can create a Report in EG, select File/New/Report.

Re: How to put outputs of proc reports or proc tabulate and proc report side by side

RW9 — Tue, 11 Jul 2017 08:04:27 GMT

You will want to look into gridded outputs to a file format which supports such a thing, the basic output window doesn't, but HTML should:

http://support.sas.com/documentation/cdl/en/odsug/69832/HTML/default/viewer.htm#p0g1r9d5mqtuezn1g3svg7lxabkx.htm

Also, avoid posting Office files, you would have seen the recent global problems, a lot came from people downloading office files - they are unsafe.

Re: How to put outputs of proc reports or proc tabulate and proc report side by side

Ksharp — Tue, 11 Jul 2017 12:12:32 GMT

ods layout gridded columns=2 advance=table;
  proc print data=sashelp.class;run;
  proc print data=sashelp.cars(obs=20);run;
ods layout end;

http://blogs.sas.com/content/iml/2015/12/02/matrices-graphs-gridded-layout.html

http://blogs.sas.com/content/iml/2016/03/02/dummy-variables-sasiml.html