About Tim_SAS

Tim_SAS · ‎12-08-2016

Excel will do that for you. In Excel 2013, choose Print, then select Fit Sheet on One Page. Here's a picture.

Tim_SAS · ‎12-07-2016

I agree with @ballardw. When you choose Excel as your reporting format then you accept its limitations, and one of its limitations is that you only get one set of columns per worksheet. ODS doesn't have any magic bullet to change that. If you must use Excel then accept it. If you must have multiple tables with different column widths per "page," then use a different report format.

Tim_SAS · ‎12-07-2016

You can use the ABSOLUTE_COLUMN_WIDTH option to change the column widths on each separate worksheet but (to be absolutely obvious), because there is only one set of columns on a worksheet, if you have more than one table on a worksheet then all the tables must have the same column widths.

Tim_SAS · ‎11-21-2016

In general you can create a very long SAS statement by simply breaking the statement across several lines. data _null_; put "This is a statement that starts on one line and ends on the next"; run;

Tim_SAS · ‎11-16-2016

Here are links to the online SAS 9.4 doc for formats by category, and for informats by category.

Tim_SAS · ‎11-11-2016

Not using a style template. The style template applies to the the entire .pptx file, so if the template removes the table/data/header borders then they're removed from all the tables. You can specify different border styles on the tables created by PROC REPORT, PRINT, and TABULATE using STYLE= options, as @Cynthia_sas demonstrated.

Tim_SAS · ‎11-11-2016

You forgot to specify your new style with the STYLE= option on your ODS POWERPOINT statement. ods powerpoint file='/sas/goodresult.pptx' style=mystyle;

Tim_SAS · ‎11-11-2016

Oh, and you'll have to remove the borders in the Header class as well. ods path (prepend) work.templat(update); proc template; define style mystyle; parent=styles.powerpointlight; class Table, Data, Header / borderwidth = 0 ; end; run; ods powerpoint file="example.pptx" style=mystyle; proc print data=sashelp.class(obs=6); run; ods powerpoint close;

Tim_SAS · ‎11-11-2016

The table and cell borders are controlled by the Table and Data style classes. Set the borderwidth to 0 to eliminate the borders. ods path (prepend) work.templat(update); proc template; define style mystyle; parent=styles.powerpointlight; class Table, Data / borderwidth = 0 ; end; run; ods powerpoint file="example.pptx" style=mystyle; proc print data=sashelp.class(obs=6); run; ods powerpoint close;

Tim_SAS · ‎11-11-2016

It is not possible to customize the amount of space used by the various page elements other than the ways I described in my paper. You can move the footnote to the bottom right by suppressing or moving the slide number and date (options nodate nonumber, for example) and right-adjusting the footnote text. When you suppress the slide number and date, or move them to the top of the slide, the footnote space widens to occupy the entire width of the slide. Then you can right-adjust the footnotes text so that it butts up to the right side of the slide. proc template; define style mystyle; parent = styles.powerpointlight; class SystemFooter / just=r ; end; run; options nodate nonumber; ods powerpoint file="test.pptx" style=mystyle; title 'Right-adjusted footnote'; footnote 'The ODS Destination for PowerPoint'; proc print data=sashelp.class(obs=6); run; ods powerpoint close;

Tim_SAS · ‎11-10-2016

I'm sorry but I don't quite understand your question. The position of the slide number, date, and footnotes at the bottom of the slide are interrelated and a change in the position of any one can affect the others. In my paper A Second Look at the ODS Destination for PowerPoint I discuss how the position of footnotes, slide numbers, and the current date relate to each other. See pages 5-7 and Figure 11.

Tim_SAS · ‎11-10-2016

This is not possible with the ODS destination for PowerPoint.

Tim_SAS · ‎11-02-2016

You can use the ODS SELECT and EXCLUDE statements to choose which tables are added to your final document. Notice that you can optionally specify individual destinations in these statements, so that you could (if you wanted to) add a table or graph to an RTF report but exclude it from an HTML web page. If that's not enough control, check out the ODS DOCUMENT destination. You can route all your output into a document, then selectively replay it to an RTF file.

Tim_SAS · ‎11-01-2016

Works for me:

Tim_SAS · ‎10-31-2016

It's difficult to say without more information about PCT_IND7AST2. What is the DEFINE statement for this variable? My previous advice applied to ANALYSIS vars with the default statistic SUM.

Online Status	Offline
Date Last Visited	‎10-19-2017 03:54 PM

Re: How to change the column width with ods excel sas 9.4

Re: How to change the column width with ods excel sas 9.4

Re: How to change the column width with ods excel sas 9.4

Re: Maximum line length of 255 character

Re: Date Formats

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to macro page number

Re: NOPRINT option not working -or how to suppress creation of an .lst...

Re: proc report compute block unquotes macro variables?

Re: Proc Report - Coloring for Spanning Headers

Re: Print SAS Code to Output File

Re: List All Macro Variables Created

Re: Saving Frequency Tables in Excel

Re: Stop FORMAT from printing values to LOG

Re: How to change the column width with ods excel sas 9.4

Re: How to change the column width with ods excel sas 9.4

Re: How to change the column width with ods excel sas 9.4

Re: Maximum line length of 255 character

Re: Date Formats

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to remove the frame line and gridded lines from the tables tha...

Re: How to macro page number

Re: How to macro page number

Re: How to macro page number

Re: Combining ODS output with RTF sandwich and %include

Re: Using macro variable in %Let

Re: PROC REPORT color code a cell based on the value