topic Re: Need to Create the Cover Page for the Report in xlxs as per the attachment. Please help!! in SAS Enterprise Guide

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

Ninja_turtle — Tue, 16 Apr 2024 12:12:54 GMT

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

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

Reeza — Tue, 16 Apr 2024 19:07:23 GMT

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.

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

Ninja_turtle — Wed, 17 Apr 2024 07:12:05 GMT

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 🙂