Todd, Which variable contains the long numerals?

From the looks of it, you're not applying the two styles you've created in the new template.

Though I haven't found success in getting a comma style that I've created in my template code, you could try something like (untested):

<ods code> Proc print ; Var charvar1-charvar10 / style(data)={data_text}; Var numvar1-numvar10 / style(data)={data_zip}; Run; <end of ods code>

You can specify for each collection of variables certain styles, like fonts etc.

I've run into the xml file not opening in Excel for some difficult-to-find reason (error in the xml code?) - see strange pop-up error message in Excel - which seems to be based on the file style or trying to add in HTMLClass/Excel formatting like the above.

John Gerstle, MS Biostatistician Northrop Grumman CDC Information Technological Support Contract (CITS) NCHSTP \DHAP \HICSB \Research, Analysis, and Evaluation Section Centers for Disease Control and Prevention

"Boss. We've got cats." "Meow"

"All truth passes through three stages: First, it is ridiculed; Second, it is violently opposed; Third, it is accepted as being self-evident." - Arthur Schopenhauer (1830)

>>-----Original Message----- >>From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu] >>On Behalf Of Todd Welsh >>Sent: Thursday, September 21, 2006 3:52 PM >>To: SAS-L@LISTSERV.UGA.EDU >>Subject: Re: Excel XML >> >>The following code is producing the Excel XML File: >> >> >>ODS LISTING CLOSE; >> >>ODS TAGSETS.EXCELXP STYLE=AAAMIDATLANTIC >>FILE="V:\DatabaseMarketing\InsAgency\Monthly_OBTM\OUTPUT\LETTERS\CRM_O CT06 >>_D >>MLEADS_EXISTINGMEMBERS_1STMAILING.XML" >>; >> >>DATA TEMP(KEEP = MEMBERSHIPID CLUB_NBR PROMOCODE PRIMARY_FIRST_NAME >>PRIMARY_MI >> PRIMARY_LAST_NAME PRIMARY_ADDR_1 PRIMARY_ADDR_2 >> PRIMARY_CITY_NM PRIMARY_ST_NM CUST_ZIP5 ASSOCIATE >> TITLE AGENT_PHONE_FMT AGENT_EXT AGENT_EMAIL_FMT >> BRANCHNAME AGENT_ADDRESS1 AGENT_ADDRESS2 AGENT_CITY >> AGENT_STATE AGENT_ZIP5 AGENT_PHONE_FMT AGENT_FAX LEAD_TYPE >> WHERE=(INDEX(PROMOCODE, 'A1') > 0 AND LEAD_TYPE = 'E')); >> >> SET NMBR_INS.AGENCYLEADS_OCT06DM; >> >> LENGTH AGENT_ZIP5 $5. CUST_ZIP5 $5.; >> >> CLUB_NBR = 212; >> PRIMARY_MI = ' '; >> >> LABEL >> MEMBERSHIPID = 'MEMBER_ID' >> CLUB_NBR = 'CLUB_NBR' >> PROMOCODE = 'PROMO_NBR' >> PRIMARY_FIRST_NAME = 'CUST_FIRSTNAME' >> PRIMARY_MI = 'CUST_MI' >> PRIMARY_LAST_NAME = 'CUST_LASTNAME' >> PRIMARY_ADDR_1 = 'CUST_ADDRESS1' >> PRIMARY_ADDR_2 = 'CUST_ADDRESS2' >> PRIMARY_CITY_NM = 'CUST_CITY' >> PRIMARY_ST_NM = 'CUST_STATE' >> CUST_ZIP5 = 'CUST_ZIP' >> ASSOCIATE = 'AGENT_NAME' >> TITLE = 'AGENT_TITLE' >> AGENT_PHONE_FMT = 'AGENT_PHONE' >> AGENT_EXT = 'AGENT_EXTENTION' >> AGENT_EMAIL_FMT = 'AGENT_EMAIL' >> BRANCHNAME = 'OFFICE_NAME' >> AGENT_ADDRESS1 = 'OFFICE_ADDRESS1' >> AGENT_ADDRESS2 = 'OFFICE_ADDRESS2' >> AGENT_CITY = 'OFFICE_CITY' >> AGENT_STATE = 'OFFICE_STATE' >> AGENT_ZIP5 = 'OFFICE_ZIP' >> AGENT_PHONE_FMT = 'OFFICE_PHONE' >> AGENT_FAX = 'OFFICE_FAXNUMBER' >> LEAD_TYPE = 'LEADTYPE'; >> >> AGENT_ZIP5 = SUBSTR(LEFT(AGENT_ZIP),1,5); >> CUST_ZIP5 = SUBSTR(LEFT(PRIMARY_ZIP_CD),1,5); >>RUN; >> >>PROC PRINT DATA=TEMP NOOBS LABEL; >> VAR MEMBERSHIPID >> CLUB_NBR >> PROMOCODE >> PRIMARY_FIRST_NAME >> PRIMARY_MI >> PRIMARY_LAST_NAME >> PRIMARY_ADDR_1 >> PRIMARY_ADDR_2 >> PRIMARY_CITY_NM >> PRIMARY_ST_NM >> CUST_ZIP5 >> ASSOCIATE >> TITLE >> AGENT_PHONE_FMT >> AGENT_EXT >> AGENT_EMAIL_FMT >> BRANCHNAME >> AGENT_ADDRESS1 >> AGENT_ADDRESS2 >> AGENT_CITY >> AGENT_STATE >> AGENT_ZIP5 >> AGENT_PHONE_FMT >> AGENT_FAX >> LEAD_TYPE; >>RUN; >>QUIT; >> >>ODS TAGSETS.EXCELXP CLOSE; >> >>Now here is the Proc Template that I've attempted to use: >> >>PROC TEMPLATE; >> DEFINE STYLE STYLES.AAAMIDATLANTIC; >> PARENT = STYLES.JOURNAL; >> >> REPLACE COLORS / >> 'DOCBG' = _UNDEF_ >> 'CONTENTBG' = CXFFFFFF >> 'CONTENTFG' = CX000000 >> 'TITLEFG' = _UNDEF_ >> 'LINK2' = _UNDEF_ >> 'LINK1' = _UNDEF_ >> 'BG5' = _UNDEF_ >> 'BG4' = _UNDEF_ >> 'BG3' = _UNDEF_ >> 'FG4' = _UNDEF_ >> 'FG3' = _UNDEF_ >> 'BG2' = CXFFFFFF >> 'FG2' = CX000000 >> 'BGA1' = _UNDEF_ >> 'FGA1' = _UNDEF_ >> 'FG' = _UNDEF_ >> ; >> >> STYLE DATA_TEXT FROM DATA / >> TAGATTR = 'FORMAT:TEXT'; >> STYLE DATA_ZIP FROM DATA / >> TAGATTR='FORMAT:00000'; >> >> END; >>RUN; >>QUIT;