September 2019
Beginner to intermediate
346 pages
7h 35m
English
It's not just data that we can export to Excel and other destinations. We can also export charts. By default, when you run multiple procedures (be it for producing data or chart output) in the same ODS statement, multiple sheets are created in Excel. Use the Sheet_interval option to ensure that you get the output in the same sheet if needed:
ODS Excel File = '/folders/myfolders/Chart_Graph_Same_Page.xlsx' Options (Sheet_interval='None');Proc Means Data=Class; Var Height;Run;Proc SGPLOT Data = Class; Histogram Height; Title 'Height of children in class across years';Run;ODS Excel Close;
This produces the following output:
Read now
Unlock full access