want to export multiple data set in Excel file

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 78
Accepted Solution

want to export multiple data set in Excel file

Hi

I have multiple sas data set and i want to export in single excel file in multiple sheets.

Regards

Tarun Kumar


Accepted Solutions
Solution
‎12-06-2013 10:37 AM
Super User
Posts: 19,869

Re: want to export multiple data set in Excel file

Posted in reply to TarunKumar

Proc Export works great, Try it with File>Export and then there's an option at the end to save your code so you can see it and modify it.

Tagsets work well, but don't generate a native Excel file

Base SAS: Demo: ExcelXP Tagset and Microsoft Excel

This is a common question...

View solution in original post


All Replies
Respected Advisor
Posts: 3,799

Re: want to export multiple data set in Excel file

Posted in reply to TarunKumar

Depends on OS and SAS products you have licensed.

Frequent Contributor
Posts: 78

Re: want to export multiple data set in Excel file

Posted in reply to data_null__

os = winwod, yes i have licenced SAS

Occasional Contributor
Posts: 12

Re: want to export multiple data set in Excel file

Posted in reply to TarunKumar

you can use ods tagset.excelxp

and export multiple datasets to multiple sheets of an excel.

Frequent Contributor
Posts: 78

Re: want to export multiple data set in Excel file

Dear Naziya,

pls share the code.

Regards

Tarun Kumar

Solution
‎12-06-2013 10:37 AM
Super User
Posts: 19,869

Re: want to export multiple data set in Excel file

Posted in reply to TarunKumar

Proc Export works great, Try it with File>Export and then there's an option at the end to save your code so you can see it and modify it.

Tagsets work well, but don't generate a native Excel file

Base SAS: Demo: ExcelXP Tagset and Microsoft Excel

This is a common question...

Frequent Contributor
Posts: 78

Re: want to export multiple data set in Excel file

Thanx Raeeza

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 309 views
  • 0 likes
  • 4 in conversation