https://communities.sas.com/t5/SAS-Procedures/Stack-Reports-ODS-Excel/m-p/797691#M81605 <P>Hi,<BR />I need to output data to xlsx in the form:<BR />value 01 02 03<BR />brand SK NI VG<BR />sum1 €36.000 ... ...<BR />dates 22.2.2022 ... ...<BR /><BR />I can create properly every line, but I need a proc report for each. I'm using options(sheet_interval='none').<BR />The problem is that there is a blank row between each output. Is there a way to get rid of them?<BR />code:<BR />Proc Report;<BR />column text dummy value, brand;<BR />define text / ' ' computed;<BR />define dummy / group noprint;<BR />define value/ across;<BR />define brand / ' ' group;<BR />compute text / char;<BR />text = "brand”;<BR />endcomp;<BR />run;</P> Tue, 22 Feb 2022 11:13:00 GMT eugeniothierry 2022-02-22T11:13:00Z https://communities.sas.com/t5/SAS-Procedures/Stack-Reports-ODS-Excel/m-p/797691#M81605 <P>Hi,<BR />I need to output data to xlsx in the form:<BR />value 01 02 03<BR />brand SK NI VG<BR />sum1 €36.000 ... ...<BR />dates 22.2.2022 ... ...<BR /><BR />I can create properly every line, but I need a proc report for each. I'm using options(sheet_interval='none').<BR />The problem is that there is a blank row between each output. Is there a way to get rid of them?<BR />code:<BR />Proc Report;<BR />column text dummy value, brand;<BR />define text / ' ' computed;<BR />define dummy / group noprint;<BR />define value/ across;<BR />define brand / ' ' group;<BR />compute text / char;<BR />text = "brand”;<BR />endcomp;<BR />run;</P> Tue, 22 Feb 2022 11:13:00 GMT https://communities.sas.com/t5/SAS-Procedures/Stack-Reports-ODS-Excel/m-p/797691#M81605 eugeniothierry 2022-02-22T11:13:00Z