want to export multiple data set in Excel file

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 75
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: 17,912

Re: want to export multiple data set in Excel file

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,777

Re: want to export multiple data set in Excel file

Depends on OS and SAS products you have licensed.

Frequent Contributor
Posts: 75

Re: want to export multiple data set in Excel file

os = winwod, yes i have licenced SAS

Occasional Contributor
Posts: 12

Re: want to export multiple data set in Excel file

you can use ods tagset.excelxp

and export multiple datasets to multiple sheets of an excel.

Frequent Contributor
Posts: 75

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: 17,912

Re: want to export multiple data set in Excel file

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: 75

Re: want to export multiple data set in Excel file

Thanx Raeeza

☑ This topic is solved.

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

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