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.
After I installed SAS Add-In for Microsoft Office the issue was resolved.
I tried your exact code, except I needed quotes around the url as below:
ods path(prepend) work.templat(update);
filename temp url "http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/msoffice2k_x.sas"; %include temp;
run;
and it worked perfectly in my EG session. Could be some characters got dropped on the data transfer?!?
Tom
After I installed SAS Add-In for Microsoft Office the issue was resolved.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.