Hi, I need to output data to xlsx in the form: value 01 02 03 brand SK NI VG sum1 €36.000 ... ... dates 22.2.2022 ... ...
I can create properly every line, but I need a proc report for each. I'm using options(sheet_interval='none'). The problem is that there is a blank row between each output. Is there a way to get rid of them? code: Proc Report; column text dummy value, brand; define text / ' ' computed; define dummy / group noprint; define value/ across; define brand / ' ' group; compute text / char; text = "brand”; endcomp; run;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.