That tip sheet is accurate for ODS EXCEL in SAS 9.4M3, but not for 9.4M2. ... View more

The default style for ODS EXCEL in 9.4M2 is HTMLBlue. ... View more

Q2 is easy enough to test. What is the output from this program?   libname t1 "C:\t1"; libname t2 "C:\t2"; data t1.test; x = 'This is the data set in T1'; data t2.test; x = 'This is the data set in T2'; libname both ("C:\t1" "C:\t2"); title 'T1 is first'; proc print data=both.test; run; libname both clear; libname both ("C:\t2" "C:\t1"); title 'T2 is first'; proc print data=both.test; run; ... View more

I use these options when I run into problems with insufficient memory. FULLSTIMER causes SAS to add memory usage statistics to the log. MEMSIZE changes the amount of memory available to SAS. This is typically a 2-step process. First, I run the problem program with both FULLSTIMER and MEMSIZE MAX and check the log to see how much memory SAS actually needed to run the program. Second, I add OPTIONS MEMSIZE nn to the program, where nn is the amount of memory SAS needed plus a little bit more for "breathing room."   You didn't say which O/S you're using, so here's the doc for MEMSIZE and FULLSTIMER for Windows. Both options can be used in a configuration file or at SAS invocation. Here's doc on how to do this on Windows.   It may be that your program doesn't complete even when you use MEMSIZE MAX, but solving that program requires more detail about your program. ... View more

You can use the ODS destination for Excel to put SAS output into an Excel 2010/2013 workbook. Similarly you can use the ODS RTF or ODS TAGSETS.RTF destination to create an RTF file that MS Word can read. The ODS User's Guide is here and there are many useful resources on http://support.sas.com. ... View more

SAS should never fail with this kind of error. Contact SAS Technical Support. They're in the best position to be able to diagnose the problem and provide you with a fix or workaround. ... View more