Desktop productivity for business analysts and programmers

Does SAS EG42 have the capability to export to a fixed excel template?

Reply
Contributor
Posts: 30

Does SAS EG42 have the capability to export to a fixed excel template?

Hi

Is there a way in EG where we can export a sas dataset to a fixed template(excel/word) so that I can have a formatted output?

Thanks

Community Manager
Posts: 2,887

Re: Does SAS EG42 have the capability to export to a fixed excel template?

There isn't a built-in method in EG 4.2 for this.

If you have the SAS Add-In for Microsoft Office, you can "pull" SAS results into any worksheet and retain your desired layout and formatting.

See other code-based methods here:

How do I export from SAS to Excel files: Let me count the ways - The SAS Dummy

Chris

Ask a Question
Discussion stats
  • 1 reply
  • 177 views
  • 4 likes
  • 2 in conversation