About Tim_SAS

Tim_SAS · ‎07-29-2016

Make sure you use a binary mode ftp. If you use text mode it will corrupt the zip file.

Tim_SAS · ‎07-28-2016

Just addressing the ~{newline} question. The ~{newline} inline function is newer and is preferred over old-school ~n. Here's the doc about ODS inline functions.

Tim_SAS · ‎07-27-2016

This largely depends on which destination you're using (PDF? HTML?) and which style. Tech Support has a lot of experience with this kind of question. I recommend that you contact them directly.

Tim_SAS · ‎07-27-2016

You're right. I replied too quickly. That's what I get for reading SAS Communities before I've had my coffee.

Tim_SAS · ‎07-26-2016

You're welcome! Don't feel too embarrassed. I would have expected SAS to have diagnosed those color names. Offhand I don't know why it doesn't. Anyway, at this year's SGF in Las Vegas I gave a follow-on to the 2013 paper called (unimaginatively) A Second Look at the ODS Destination for PowerPoint. I hope you find it useful.

Tim_SAS · ‎07-26-2016

You're almost there. The color names should start with cx, not #cx. scheme 'ODS Light' / dark1 = cx565656 light1 = cxffffff dark2 = cx565656 light2 = cxffffff accent1 = cx98012E accent2 = cx565656 accent3 = cxffffff accent4 = cxffffff accent5 = cxffffff accent6 = cxffffff heading_font = ("Arial",32pt) body_font = ("Arial",20pt);

Tim_SAS · ‎07-26-2016

This is a recurring topic. Here's good information about numerical accuracy in SAS programs.

Tim_SAS · ‎07-25-2016

Looks like you're missing the COMPUTE statement that should precede Tot_Forecast=Tot_Budget.sum*Probabilty*0.01;

Tim_SAS · ‎07-22-2016

SAS thinks your macro variable is &datasets_JUL_2016. Put a period between datasets and _JUL, like this: &datasets._JUL_2016

Tim_SAS · ‎07-20-2016

Well, you can't "remove" the formatting but you can change it. When you say "the output window" are you talking about the old monospace output window or the new (SAS 9.3) HTML output? If the old, then you might try using the Monospace style on your PDF output. If the new HTML output, then use the HTMLBlue style.

Tim_SAS · ‎07-14-2016

Does the "non-working" user have the RSASUSER option in a config file? Is the "non-working" user's SASUSER directory write-protected?

Tim_SAS · ‎07-08-2016

The creation of new worksheets is controlled by the SHEET_INTERVAL keyword in the OPTIONS() option. Your program sets sheet_interval="none", so all the program output will go on the same worksheet. Change the value of sheet_interval as necessary to put your program output to go on new sheets.

Tim_SAS · ‎06-30-2016

The Excelxp tagset (and the new ODS destination for Excel) creates titles by merging multiple cells in the row. Excel's Autoheight feature doesn't work on rows that contain merged cells. This is an Excel limitation. You should be able to use the ROW_HEIGHTS keyword in the OPTIONS() option to specify a height for the title row.

Tim_SAS · ‎06-28-2016

Usage Note 39499: Convert a UNIX datetime to a SAS® datetime http://support.sas.com/kb/39/499.html

Tim_SAS · ‎06-28-2016

Did you forget to add the ODS ESCAPECHAR='^'; statement?

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: ftp issue with zip files in SAS

Re: Long Variable runs off page in Proc Report-indent?

Re: SAS ODS in 9.3 vs 9.4

Re: Expected numeric precision behaviour or unexpected issue?

Re: ODS Powerpoint - how to change font color

Re: ODS Powerpoint - how to change font color

Re: Expected numeric precision behaviour or unexpected issue?

Re: PROC Report

Re: how to make proc report read from multiple data sets?

Re: Printing contents of the Output window

Re: PROC TEMPLATE: Unable to write to template store

Re: ods excel multiple sheets

Re: How to - Make Fit Reports Widths and Heights for Tagset.ExcelXP Re...

Re: datetime informat

Re: ods pdf text= style optiom