topic Re: Defining range in excel while exporting through proc tabulate in SAS Programming https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766171#M242789 <P>I didn't get you.</P><P>Could you please explain further?</P><P>&nbsp;</P> Mon, 06 Sep 2021 07:40:32 GMT Yash2910 2021-09-06T07:40:32Z Defining range in excel while exporting through proc tabulate https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766005#M242691 Hello community,<BR />I have two reports which i want to paste on a single excel sheet but with few column space between those two reports.<BR />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.<BR /> Sat, 04 Sep 2021 05:30:01 GMT https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766005#M242691 Yash2910 2021-09-04T05:30:01Z Re: Defining range in excel while exporting through proc tabulate https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766093#M242744 <P>Have you tried creating the 2 ranges, and exporting to these ranges?</P> Sun, 05 Sep 2021 06:58:31 GMT https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766093#M242744 ChrisNZ 2021-09-05T06:58:31Z Re: Defining range in excel while exporting through proc tabulate https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766171#M242789 <P>I didn't get you.</P><P>Could you please explain further?</P><P>&nbsp;</P> Mon, 06 Sep 2021 07:40:32 GMT https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766171#M242789 Yash2910 2021-09-06T07:40:32Z Re: Defining range in excel while exporting through proc tabulate https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766274#M242840 <P>Do you know about excel ranges? See <A href="https://blogs.sas.com/content/sasdummy/2018/06/21/read-excel-range/" target="_self">here</A></P> <P>And see <A href="https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-results-to-a-named-range-in-excel/td-p/425129" target="_self">here</A>&nbsp;for example about exporting to a range rather than to a sheet.</P> Mon, 06 Sep 2021 22:56:20 GMT https://communities.sas.com/t5/SAS-Programming/Defining-range-in-excel-while-exporting-through-proc-tabulate/m-p/766274#M242840 ChrisNZ 2021-09-06T22:56:20Z