It is possible to control your print options using the SAS code. This ensures that your output is not done uncontrollably. We will run the following code and look at how the options used in the code related to the print options:
ODS Excel File = '/folders/myfolders/Print_Dealership.xlsx' Options (BlackandWhite='Yes' Center_Horizontal='Yes' Center_Vertical='Yes' Draftquality='On'); Proc Print Data=Dealership;Run;ODS Excel Close;
This code will produce the Print_Dealership file in the output location we specified. When you select File and then Print from the MS Excel menu, you can see that the data is aligned at the center of the page.
Further, when you click on Page Setup and look at the Sheet tab, you can observe ...
