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.
Click image to register for webinar
