Coud anybody explain how to import data in multiple excel sheet in a single excel file by using ODS and PROD REPORT.
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#p05hxa7xihwolmn1sd... - the workbook will then appear as a library with each worksheet appearing as a seperate data set
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)?
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.
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 .
@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.
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.