Defining range in excel while exporting through proc tabulate - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

Defining range in excel while exporting through proc tabulate

Posted 09-04-2021 01:30 AM (456 views)

Hello community,
I have two reports which i want to paste on a single excel sheet but with few column space between those two reports.
I have a proc tabulate code to run after which those two reports are created. I want to make such a code so that both the reports are created on a single excel sheet with some space between them.

3 REPLIES 3

Tourmaline | Level 20

Tourmaline | Level 20

Re: Defining range in excel while exporting through proc tabulate

Posted 09-05-2021 02:58 AM (365 views) | In reply to Yash2910

Have you tried creating the 2 ranges, and exporting to these ranges?

High-Performance SAS Coding - Third Edition

Calcite | Level 5

Calcite | Level 5

Re: Defining range in excel while exporting through proc tabulate

Posted 09-06-2021 03:40 AM (323 views) | In reply to ChrisNZ

I didn't get you.

Could you please explain further?

Tourmaline | Level 20

Tourmaline | Level 20

Re: Defining range in excel while exporting through proc tabulate

Posted 09-06-2021 06:56 PM (291 views) | In reply to Yash2910

Do you know about excel ranges? See here

And see here for example about exporting to a range rather than to a sheet.

High-Performance SAS Coding - Third Edition