topic Re: How can I use SAS to produce a report? in ODS and Base Reporting

How can I use SAS to produce a report?

SM8 — Wed, 10 Jun 2020 01:56:39 GMT

How can I use SAS to produce an Excel report with the following included in the report:

• Tabs for each business: BM part A, BM part b, BJ part a , BJ part b, and SSB
• Case specific information: IDN, BSN, Doc_ID
• Date (dt) Ranging from 3/1/20 – 3/30/20

I'm new to SAS, but I do believe SQL would be easiest to complete this. Any advice/suggested code would be helpful. Thanks!

Re: How can I use SAS to produce a report?

Kurt_Bremser — Wed, 10 Jun 2020 04:49:31 GMT

PROC REPORT has most, if not all options you need, and ODS EXCEL will give you control over sheet changes and sheet names (among others).

For detailed help, provide example data in usable form (data step with datalines), and an example for the expected result in Excel.

Re: How can I use SAS to produce a report?

Cynthia_sas — Wed, 10 Jun 2020 23:43:07 GMT

Hi:

Here's something to get you started. You could use SQL to generate the macro variables that I show with %LET statements in my program:

But I think that PROC REPORT gives you the most flexibility as far as using dynamic information for the sheet names, titles and table captions using the LINE statement.

Cynthia