msoffice2k_x.sas errors

pope1970 — Thu, 14 Feb 2013 19:11:18 GMT

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.

Re: msoffice2k_x.sas errors

TomKari — Thu, 21 Feb 2013 17:42:06 GMT

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

Re: msoffice2k_x.sas errors

pope1970 — Mon, 25 Feb 2013 17:11:45 GMT

After I installed SAS Add-In for Microsoft Office the issue was resolved.

topic Re: msoffice2k_x.sas errors in SAS Enterprise Guide

msoffice2k_x.sas errors

Re: msoffice2k_x.sas errors

Re: msoffice2k_x.sas errors