ODS

[Reddi]

Hi ,

I've multiple datasets and need to send them through in a single email in the below required format.

The format is attachedand requrements are

1. Columns should be freezed , filled with colour attributes (R:G:B=0:0:128),font=9,fontcolour=White

2. Data : Font_type=Arial ,font=8,fontcolour=Black

Many Thanks in advance...!

[PaigeMiller]

Could you clarify something?

Are you sending Excel files, or SAS data sets, or something else?

[Reddi]

Hi ,

I've datasets and need to convert them and send as excel attachments.

[PaigeMiller]

ODS EXCEL combined with PROC REPORT or PROC PRINT can certainly produce what you want.

See

https://support.sas.com/resources/papers/proceedings16/SAS5642-2016.pdf

http://support.sas.com/documentation/cdl/en/odsug/69832/HTML/default/viewer.htm#p09n5pw9ol0897n1qe04...

[Reeza]

So which part of that do you need help with?

You've posted your requirements, are you expecting code to satisfy your requirements or do you need help with the process?