topic Re: proc report output for two reports in ODS and Base Reporting

proc report output for two reports

75063 — Thu, 30 Aug 2018 03:18:01 GMT

Is it possible to concatenate two or more proc reports?

The proc reports look like these -

data have;
input brand $ Freq Freq1 perchange;
datalines;
A 2 3 8
B 3 5 4
C 4 6 2
D 5 1 1
E 6 5 8
F 7 7 9
;
run;

proc report data=have nowd out=abs
style(summary)=Header;
title 'Proc Report Crosstab Report';
column brand
('Enrollment' Freq Freq1 perChange);
define brand / group "Enrollment by Residency";
rbreak after / summarize;
run;

data have1;
input cars $ Freq Freq1 perchange;
datalines;
A 4 1 9
B 6 0 5
C 8 1 6
D 1 6 8
E 7 4 4
F 6 5 1
;
run;

proc report data=have1 nowd out=abs1
style(summary)=Header;
title 'Proc Report Crosstab Report';
column cars
('Enrollment1' Freq Freq1 perChange);
define brand / group "Enrollment1 by College";
rbreak after / summarize;
run;

So the two Proc reports have out "abs" and "abs1".

My report should output the two reports one after then other in the order and have two blank spaces between them. I have attached a sample report that I would need as an output.

When I use the following code my output is not like the one that I desire (attached with the post)

proc report data=have nowd out=abs
style(summary)=Header;
title 'Proc Report Crosstab Report';
column brand
('Enrollment' Freq Freq1 perChange);
define brand / group "Enrollment by Residency";
rbreak after / ;
column brand
('Enrollment1' Freq Freq1 perChange);
define brand / group "Enrollment1 by college";
rbreak after /;
run;

Can someone please suggest a possible solution.

Re: proc report output for two reports

Cynthia_sas — Thu, 30 Aug 2018 05:08:39 GMT

Hi:
Other than the fact that you might have more than "2 spaces" between the 2 tables, what is wrong with your existing reports? And, how do you measure 2 spaces?

What is your destination of choice? RTF, PDF, HTML? Or???

I don't understand the purpose of creating output datasets ABS and ABS1 -- do you have something else to do with those datasets?

Cynthia

Re: proc report output for two reports

75063 — Thu, 30 Aug 2018 05:51:36 GMT

Hi Cynthia,

Thankyou for your reply.

I wanted the proc reports for the two datasets 'have' and 'have1' to be output one after the other, rather than merge horizontally as it was with the code I had provided.

The two data sets are completely independent of each other.

By 'Blank' i was basically asking how to insert spaces between observations. For example if a Proc report has 7 observations (independent of each other, made by concatenating from other data) how can I insert a blank between the 2nd. and 3rd. observation.

Thank you!

Re: proc report output for two reports

Cynthia_sas — Thu, 30 Aug 2018 14:14:01 GMT

Hi:

I don't understand the code that you've posted. If I run all of your posted code, here's what I get:

I don't see any place that you're using ABS and ABS1 (so I didn't bother creating them). I used your posted data.

The last PROC REPORT that you posted will NOT work to place one table AFTER the other. Your 2 COLUMN statements are not doing what you say you want because PROC REPORT doesn't place one column statement after the other, it places everything on 1 report row -- or tries to.

You still have not said what your final destination of interest is. When I use your two original PROC REPORTS with PDF and STARTPAGE=NO, this is what I get:

Which looks to me very close to what you describe.

Cynthia

Re: proc report output for two reports

75063 — Thu, 30 Aug 2018 17:34:06 GMT

Thank you for your reply.

However, i am using SAS on demand for academics so do not have the privilege of a ods output. (it gives me an error as: ERROR: Insufficient authorization to access /pbr/biconfig/940/Lev1/SASApp/c:\temp\you.pdf)

I would like the output to be in sas studio , just as a proc print output.

Is there a way to get the same output as you had in the reply in the SAS studio environment?

Regards,

Re: proc report output for two reports

Cynthia_sas — Thu, 30 Aug 2018 18:11:21 GMT

Hi:
You CAN use SAS OnDemand for Academics with ODS. Even if you're using SAS Studio or Enterprise Guide. You just have to make a folder in your Files area and then write the output there.

For example, on my SAS OnDemand for Academics, I have a folder called all_output under my /home directory. Or, on SAS University Edition, I might have a folder called all_output on my /folders/myfolders location. In either case, this is how I would create ODS output:
1) Make a folder called all_output in the correct location where you have WRITE access

2) Write the appropriate code
2a) SAS OnDemand for Academics:

ods pdf file='/home/youruserid/all_output/report.pdf';
...more code ...;
ods pdf close;
 
ods rtf file='/home/youruserid/all_output/report.rtf';
...more code ...;
ods rtf close;
 
ods html path='/home/youruserid/all_output' file='report.html';
...more code ...;
ods html close;

2b) SAS University Edition in a Virtual Machine:

ods pdf file='/folders/myfolders/all_output/report.pdf';
...more code ...;
ods pdf close;
 
ods rtf file='/folders/myfolders/all_output/report.rtf';
...more code ...;
ods rtf close;
 
ods html path='/folders/myfolders/all_output' file='report.html';
...more code ...;
ods html close;

Then, after the output is created, you have to navigate to that location and open or download the file from the output folder.

Cynthia

Re: proc report output for two reports

75063 — Thu, 30 Aug 2018 18:21:38 GMT

Thank you for the suggestion.
I wanted to read the file in the Files(Home) folder. The properties of this folder tells me that the path is : \home\myname0

So should the ods statement read like this? -
ods xls file= "\home\myname0\you.xls" startpage=no ;

and should end like
ods xls close;

However, it is still giving me an error - ERROR 180-322: Statement is not valid or it is used out of proper order.

Is this because xls is not a output type?

Re: proc report output for two reports

Cynthia_sas — Thu, 30 Aug 2018 20:17:34 GMT

Hi:
There is NOT any ODS XLS destination. You need to use either ODS EXCEL or ODS TAGSETS.EXCELXP. Like this:

SAS OnDemand for Academics

ods excel file='/home/youruserid/all_output/report.xlsx';
...more code ...;
ods excel close;
  
ods tagsets.excelxp file='/home/youruserid/all_output/report.xml';
...more code ...;
ods tagsets.excelxp close;

SAS University Edition

ods excel file='/folders/myfolders/all_output/report.xlsx';
...more code ...;
ods excel close;
  
ods tagsets.excelxp file='/folders/myfolders/all_output/report.xml';
...more code ...;
ods tagsets.excelxp close;

Note that the FILE EXTENSIONS are important.

ODS EXCEL --only-- creates .XLSX (2007 Office Open XML format for Excel) files and

ODS TAGSETS.EXCELXP works best when you use the file extension of .XML (2003 Spreadsheet Markup Language XML files).

Cynthia

Re: proc report output for two reports

75063 — Thu, 30 Aug 2018 20:43:18 GMT

Good day Cynthia,

Thank you for the detailed explanation. It really worked perfect for my problem.

Regards,