topic Re: SAS ODS with multiple sheet in ODS and Base Reporting

SAS ODS with multiple sheet

singhsahab — Sun, 17 Sep 2017 04:41:38 GMT

Coud anybody explain how to import data in multiple excel sheet in a single excel file by using ODS and PROD REPORT.

Re: SAS ODS with multiple sheet

ChrisBrooks — Sun, 17 Sep 2017 08:03:40 GMT

You can't import data with ODS and Proc Report - if you want to read an excel file with multiple worksheets you should use either the EXCEL, PCFILES or XLSX engines as shown in this link http://support.sas.com/documentation/cdl/en/acpcref/69731/HTML/default/viewer.htm#p05hxa7xihwolmn1sdjpfui9nosc.htm - the workbook will then appear as a library with each worksheet appearing as a seperate data set

Re: SAS ODS with multiple sheet

Patrick — Sun, 17 Sep 2017 09:39:53 GMT

@singhsahab

What exactly are you trying to achieve? What do you have (what's your starting point) and what do you want (what's the desired result)?

Re: SAS ODS with multiple sheet

Reeza — Sun, 17 Sep 2017 17:31:54 GMT

Making a very broad assumption that you actually mean export to Excel, see the examples here:

https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html

Otherwise, please clarify your question.

@singhsahab wrote:

Coud anybody explain how to import data in multiple excel sheet in a single excel file by using ODS and PROD REPORT.

Re: SAS ODS with multiple sheet

singhsahab — Tue, 19 Sep 2017 15:48:14 GMT

Dear Reeza,

I've two dataset tab1 and tab2. I want to export these dataset into a single excel sheet with sheet name tab1 and tab2.

I'm able to achieve this by using ODS EXCEL and PROC PRINT but i want to achieve this by using ODS EXCEL and PROC REPORT .

Re: SAS ODS with multiple sheet

singhsahab — Tue, 19 Sep 2017 15:49:08 GMT

Dear Patrick,

I've two dataset tab1 and tab2. I want to export these dataset into a single excel sheet with sheet name tab1 and tab2.

I'm able to achieve this by using ODS EXCEL and PROC PRINT but i want to achieve this by using ODS EXCEL and PROC REPORT .

Re: SAS ODS with multiple sheet

Reeza — Tue, 19 Sep 2017 15:49:09 GMT

@singhsahab wrote:

Dear Reeza,

I've two dataset tab1 and tab2. I want to export these dataset into a single excel sheet with sheet name tab1 and tab2.

I'm able to achieve this by using ODS EXCEL and PROC PRINT but i want to achieve this by using ODS EXCEL and PROC REPORT .

So replace your PROC PRINT with the PROC REPORT.

I'm not sure what the question is beyond that or how we can help you out here.