Need to Create the Cover Page for the Report in xlxs as per the attachment. Please help!!

[Ninja_turtle]

Hi All,

I am new to the ods and SAS and need to create a complex( attached )cover page. Can you please help how can I create it and export to xlxs with other tabs already present in the sheet?

if we can't push with other sheets in workbook can we at least create a separate xlxs for this?

Need help how we can create it in sas!!

Thanks,

NinJa

[Reeza]

You can create that information as data sets and then use proc report to proc print them to the XLSX file in addition to whatever the remainder of your process is for creating your Excel file.

[Ninja_turtle]

The issue is formatting how can I get extact format and color. I tried but it seems to be very ugly and not as per what my requirement is!

Please help me with code if you can  🙂