Investigate the use of SAS PROC PRINTTO with the LOG= option, mentioned in the DOC (link below). Scott Barry SBBWorks, Inc. http://support.sas.com/documentation/onlinedoc/etls/usage34.pdf Another DOC reference found at SAS support website: http://support.sas.com/documentation/cdl/en/hostwin/59544/HTML/default/win-proc-printto.htm SAS support website address: http://support.sas.com/ ... View more

DDV stands for "Data Set Data Vector." Have a look at the DOC - here in SAS 9.1 Language Reference: Concepts: http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_langref_6972.pdf Scott Barry SBBWorks, Inc. ... View more

Research your ODS HTML facility options, however I don't know of a method to directly "fuse" two PROC outputs together with "ODS HTML", assuming you do not want the HTML TABLE body content to be separate (no titles or BY separation). Programming ODS HTML to generate back-to-back PROC outputs is definitely possible, within the same HTML document, using various techniques, such as BY group processing, or iterative invocation with WHERE processing. For consideration, I find that the SAS support website at http://support.sas.com/ provides many examples and also you can search for topic-oriented references, using relative keywords and phrases. I have provided links to some related SUGI/SGF papers. Scott Barry SBBWorks, Inc. __________________ ODS HTML papers: http://www2.sas.com/proceedings/sugi29/245-29.pdf http://www2.sas.com/proceedings/sugi27/p008-27.pdf SAS Base technical resources home: http://support.sas.com/rnd/base/ ... View more

Have a look at the SAS support website http://support.sas.com/ and search for ODS MARKUP TAGSET XML for your keywords. Or, as Olivier mentioned, a simple DATA step process to an external file would be more efficient. Scott Barry SBBWorks, Inc. http://www2.sas.com/proceedings/sugi27/p134-27.pdf ... View more

Obviously it does make a difference with SAS handling CHARACTER and NUMERIC variables differently. Did a search at the SAS support website http://support.sas.com/ and this DOC gem reference comes up. Do you really need to have a mixture of macro and DATA step for your application processing? Scott Barry SBBWorks, Inc. SAS 9.2 LANGUAGE REFERENCE http://support.sas.com/documentation/cdl/en/sclref/59578/HTML/default/a000144252.htm ... View more

Sorry for the less-than-useful guidance. Check this comp.soft-sys.sas thread that is similar to yours? Mind any broken URL. Scott Barry SBBWorks, Inc. http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/67f67f471338bca6 ... View more

Search the SAS support website http://support.sas.com/ using the keywords you mention "format cell colour dde" for several related document references. Scott Barry SBBWorks, Inc. ... View more

Consider the TERMSTR option for the FILE statement in a DATA step. Have a look at the SAS support website http://support.sas.com/ and search on the parameter for DOC and other useful references. Scott Barry SBBWorks, Inc. ... View more

Without seeing your code, you may want to also consider the benefit of using the ODS parameter NEWFILE= , if you are generating a CONTENTS, FRAME and BODY set of members for your HTML/web content. This parameter can help reduce the HTML document file-size, but only under certains circumstances (and SAS PROCs). Check the SAS support website http://support.sas.com/ and search on related keywords and/or phrases to find relevant DOC and other useful FAQs, technical papers and material. Scott Barry SBBWorks, Inc. ... View more

SAS can be invoked with the CONFIG option NODMS, which brings it up in line-mode. This approach may or may not suit your requirements though. Have a look at the SAS support website at http://support.sas.com/ and search on the NODMS keyword for DOC and tips/FAQ references. Scott Barry SBBWorks, Inc. ... View more

Check out the SAS support website for info resources on TAGSETS.EXCELXP. Also, here is a particular link on an updated version of the particular tagset. Scott Barry SBBWorks, Inc. Usage Note 32394: Installing and Storing Updated Tagsets for ODS MARKUP http://support.sas.com/kb/32/394.html ODS MARKUP Resources http://support.sas.com/rnd/base/ods/odsmarkup/index.html ... View more

Possibly the COMPUTE BEFORE code block will work. Scott Barry SBBWorks, Inc. ... View more

Do consider sharing your code - at least the ODS and "HTML report" generation portion. As a consideration, review your use of NEWFILE= parameter with your ODS statement. By the way, the following Google advanced search against the SAS.COM domain/site, generated some interesting hits: ods html separate files mvshtml site:sas.com Scott Barry SBBWorks, Inc. ... View more

Please disregard the incomplete prior reply...let's try this again: Keep in mind the NODUPKEY (limited to BY variable list) option. Also, note that the NODUP option requires duplicate observations to be adjacent for them to be removed, which would be based on the BY list granularity. And, if you want to preserve the duplicate observations, there is a DUPOUT= keyword. Scott Barry SBBWorks, Inc. ... View more