topic ODS in SAS Programming

ODS

Reddi — Mon, 15 May 2017 13:04:41 GMT

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 — Mon, 15 May 2017 13:17:41 GMT

Could you clarify something?

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

Reddi — Mon, 15 May 2017 13:20:28 GMT

Hi ,

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

PaigeMiller — Mon, 15 May 2017 15:54:53 GMT

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

See

Reeza — Mon, 15 May 2017 16:31:40 GMT

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?