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

[HashimBasheer]

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

[ChrisHemedinger]

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