I entered the piece of code using the sample from http://support.sas.com/kb/43/470.html where you have ods path(prepend) work.templat(update); filename temp url http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/msoffice2k_x.sas; %include temp; but somehow when EG reads the file msoffice2k_x.sas but some of commands are not recognized and I am gettting errors as per below 494 !+"<html xmlns:x=""urn:schemas-microsoft-com:office:excel""" NL; _ 79 ERROR: Unknown symbol: 'html' ERROR: Unknown symbol: 'xmlns' ERROR: Unknown symbol: 'x' 494 + x="" __ 49 ERROR: Unknown symbol: 'urn' ERROR: Unknown symbol: 'schemas' ERROR: Unknown symbol: 'microsoft' ERROR: Unknown symbol: 'com' ERROR: Unknown symbol: 'office' 3 The SAS System 14:43 Wednesday, February 13, 2013 ERROR: Unknown symbol: 'excel' ERROR: Unknown symbol: 'xmlns' ERROR: Unknown symbol: 'v' 495 + put " xmlns:v=""urn:schemas-microsoft-com:vml"">" NL; __ 49 ERROR 79-322: Expecting a /. NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR: Unknown symbol: 'urn' ERROR: Unknown symbol: 'schemas' ERROR: Unknown symbol: 'microsoft' ERROR: Unknown symbol: 'com' ERROR: Unknown symbol: 'vml' ERROR: Unknown symbol: 'html' ERROR: Unknown symbol: 'head' ERROR: Unknown symbol: 'meta' 504 + meta 504 !+name=""Excel Workbook Frameset"">" NL /if $worksheet_source; __ 49 ERROR: Unknown symbol: 'Excel' ERROR: Unknown symbol: 'Workbook' ERROR: Unknown symbol: 'Frameset' ERROR: Unknown symbol: 'link' ERROR: Unknown symbol: 'rel' ERROR: Unknown symbol: 'File' ERROR: Unknown symbol: 'List' 519 + put "<style> @page {"; _ 22 200 4 The SAS System 14:43 Wednesday, February 13, 2013 ERROR: Unknown symbol: 'mso' ERROR: Unknown symbol: 'page' ERROR: Unknown symbol: 'orientation' ERROR: Unknown symbol: 'landscape' 520 + landscape; " / if cmp($orientation,"landscape"); _________________________ 49 520 + put " mso-page-orientation:landscape; " / if cmp($orientation,"landscape"); _________________________ 180 NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, ;, !, !!, $, &, (, ), *, **, +, ',', -, /, :, <, <=, <>, =, =<, =>, >, ><, >=, ?, @, ABBR, ABSTRACT, ACRONYM, ACTIVELINKCOLOR, AFTER, ALT, ANCHOR, AND, ANY, ARCHIVE, ASIS, ATTR_NAME, ATTR_VALUE, AUTHOR, BACKGROUNDCOLOR, BACKGROUNDIMAGE, BACKGROUNDPOSITION, BACKGROUNDREPEAT, BASENAME, BEFORE, BETWEEN, BLUE, BODYSCROLLBAR, BODYSIZE, BODY_NAME, BODY_TITLE, BODY_URL, BORDERBOTTOMCOLOR, BORDERBOTTOMSTYLE, BORDERBOTTOMWIDTH, BORDERCOLLAPSE, BORDERCOLOR, BORDERCOLORDARK, BORDERCOLORLIGHT, BORDERLEFTCOLOR, BORDERLEFTSTYLE, BORDERLEFTWIDTH, BORDERRIGHTCOLOR, BORDERRIGHTSTYLE, BORDERRIGHTWIDTH, BORDERSPACING, BORDERSTYLE, BORDERTOPCOLOR, BORDERTOPSTYLE, BORDERTOPWIDTH, BORDERWIDTH, BOTTOM, CAPSTYLE, CAPTION, CELLPADDING, CELLSPACING, CLABEL, CLASS, CLASSID, CLOSURE, CMP, CODE, CODEBASE, CODE_NAME, CODE_TITLE, CODE_URL, COLCOUNT, COLEND, COLOR, COLSPAN, COLSTART, COLUMNAXIS, COLWIDTH, COL_ID, CONNECT, CONTAINS, CONTENTPOSITION, CONTENTSCROLLBAR, CONTENTSIZE, CONTENTS_NAME, CONTENTS_TITLE, CONTENTS_URL, CONTENTTYPE, CONTRASTCOLOR, COORDINATE, CSSSTYLE, CSSTEXT, CURSOR, DATAENCODING, DATATYPE, DATA_NAME, DATA_ROW, DATA_TITLE, DATA_URL, DATA_VIEWER, DATE, DEFWIDTH, DEPTH, DESCRIPTION, DEST_FILE, DEVICE_TYPE, DIMENSION, DISPLAYOPTS, DNAME, DOCTYPE, DROPSHADOW, EMPTY, ENCODING, END, ENDCOLOR, EQ, EVENT_NAME, EXIST, EXISTS, FILL, FILLRULEWIDTH, FIRSTPAGE, FIRST_STACKED_VALUE, FLYOVER, FMTLANG, FONT, FONTFAMILY, FONTSIZE, FONTSTYLE, FONTWEIGHT, FONTWIDTH, FRAME, FRAMEBORDER, FRAMEBORDERWIDTH, FRAMESPACING, FRAME_NAME, FRAME_TITLE, FRAME_URL, FUZZ, GE, GENFORMAT, GRADIENTDIRECTION, GRAPH_PATH_NAME, GRAPH_PATH_URL, GREEN, GRSEG, GT, HEADERS, HEIGHT, HIDDEN, HREF, HREFTARGET, HTMLID, HTMLSTYLE, ID, IMAGESTYLE, IN, IN_ASSOCIATION, IN_CAPTION, IS_NOTE, IS_STACKED, IS_TITLE, JAVADATE, JAVATIME, JUST, KEEPN, LABEL, LANGUAGE, LAST_STACKED_VALUE, LE, LEFT, LEVEL, LIKE, LINESTYLE, LINETHICKNESS, LINKCOLOR, LISTENTRYANCHOR, LISTENTRYDBLSPACE, LISTSTYLEIMAGE, LISTSTYLEMARKER, LISTSTYLETYPE, LIST_INDEX, LONGDESC, LT, MARGIN, MARGINBOTTOM, MARGINLEFT, MARGINRIGHT, MARGINTOP, MARKERSIZE, MARKERSYMBOL, MAX, MIN, MINOR, MISSING, MULTILABEL, MULTIPLIER, NAME, NE, NEUTRALCOLOR, NOBASE, NOBREAKSPACE, NOCENTER, NOEDIT, NOT, NOTSORTED, NO_BOTTOM, NO_TOP, NO_WRAP, OFFSET, OPERATOR, OR, OUTPUT_LABEL, OUTPUT_NAME, OUTPUT_TYPE, OVERHANGFACTOR, PADDING, PADDINGBOTTOM, PADDINGLEFT, PADDINGRIGHT, PADDINGTOP, PAGEBREAKHTML, PAGES_NAME, PAGES_TITLE, PAGES_URL, PAGE_COLUMNS, PAGE_COUNT, PARENTMEMBER, PATH, PATH_NAME, PATH_URL, POSITION, POSTHTML, POSTIMAGE, POSTTEXT, PRECISION, PREFIX, PREHTML, PREIMAGE, PRETEXT, PROC_COUNT, PROC_NAME, PROTECTSPECIALCHARS, RAWVALUE, RED, REF_ID, REGION_HEIGHT, REGION_RAW_X, REGION_RAW_Y, REGION_WIDTH, REGION_X, REGION_Y, RIGHT, ROUND, ROW, ROWAXIS, ROWSPAN, RULES, SASFORMAT, SASLONGVERSION, SASVERSION, SCALE, SECTION, SECTIONDATA, SHAPE, 5 The SAS System 14:43 Wednesday, February 13, 2013 SLICEAXIS, SPACE, SPLIT, START, STARTCOLOR, STARTVALUE, STATE, STYLE, STYLESHEET_NAME, STYLESHEET_TITLE, STYLESHEET_URL, STYLE_ELEMENT, SUFFIX, SUMMARY, SUPPRESS_CHARSET, TAGATTR, TAGSET, TAGSET_ALIAS, TAG_NAME, TARGET, TEXT, TEXTALIGN, TEXTDECORATION, TEXTINDENT, TEXTJUSTIFY, THRESHOLD, TICKDISPLAY, TIME, TITLE, TOC_LEVEL, TOP, TOTAL_PAGE_COUNT, TOTAL_PROC_COUNT, TRANSPARENCY, TRANTAB, TRIGGER_NAME, TYPE, UNFORMATTEDTYPE, UNFORMATTEDVALUE, UNFORMATTEDWIDTH, URL, VALIDATED_DEVICE, VALUE, VALUESCOUNT, VERTICALALIGN, VISITEDLINKCOLOR, VJUST, VMERGE, WATERMARK, WHITESPACE, WIDTH, XMLCDATA, XMLCONTROL, XMLDATAFORM, XMLMETADATA, XMLPARM, XMLSCHEMA, ^, ^=, _NAME_, _VALUE_, |, ~, ~=. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 180-322: Statement is not valid or it is used out of proper order. 521 + putq " mso-header-data:" $print_header ";" NL /if $print_header; ______________________________________________ 180 522 + putq " mso-footer-data:" $print_footer ";" NL /if $print_footer; ______________________________________________ 180 523 + put " margin: " $margin ";" NL / if $margin; _____________________________________________________________ 180 524 + put " margin-left:" $left_margin ";" NL / if $left_margin;; ____________________________________________________ 180 525 + put " margin-right:" $right_margin ";" NL / if $right_margin; ; __________________________________________________ 180 526 + put " margin-top:" $top_margin ";" NL / if $top_margin;; ______________________________________________________ 180 527 + put " margin-bottom" $bottom_margin ";" NL / if $bottom_margin; _________________________________________________ 180 528 + put " mso-header-margin:" $header_margin ";" NL /if $header_margin; ____________________________________________ 180 529 + put " mso-footer-margin:" $footer_margin ";" NL /if $footer_margin; ____________________________________________ 180 547 + putq " mso-displayed-decimal-separator:" $decimal_separator ";" _ 180 547 !+ NL; 548 + putq " mso-displayed-thousand-separator:" $thousand_separator ";" _ 180 548 !+ NL; 553 + put " background-color:" $banner_even " !important;" _ 180 553 !+ NL / if $banner_even; 554 + put " color:" $fbanner_even " !important;" NL / if $fbanner_even; 6 The SAS System 14:43 Wednesday, February 13, 2013 _________________________________________ 180 558 + put " background-color:" $banner_odd " !important;" _ 180 558 !+ NL / if $banner_odd; 559 + put " color:" $fbanner_odd " !important;" NL / if $fbanner_odd; __________________________________________ 180 650 + put " </x:PageBreaks>" NL; ________________________________________________________________ 49 ERROR 180-322: Statement is not valid or it is used out of proper order.
... View more