The SAS Output Delivery System and reporting techniques

Issue with Tagset MSOffice2K_x (Error while submitting)

Reply
New Contributor
Posts: 4

Issue with Tagset MSOffice2K_x (Error while submitting)

Hi All,

 

I downloaded the MS Office 2k_x tagset from below mentioned site 

http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/ and saved it in .tpl format in folder called  G:\Excel\

 

 I tried submitting the following codes,but its showing error. How to get rid of this error  ? Is anyone facing the same error as me ?

 

  %include "G:\Excel\msoffice2k_x.tpl";

 

Errors (From Log)

 

eval $data_row inputn(data_row,"best");
10051 +
10052 + do /if mod($data_row, 2);
10053 +
10054 + do /if any( $banner_odd, $fbanner_odd);
10055 + put " class=""second""" ;
10056 + else;
10057 + done;
^
ERROR: Unknown tagset statement
10058 +
10059 + else;
^
ERROR: Statement "else" is not valid
10060 +
10061 + do /if any( $banner_even, $fbanner_even);
10062 + put " class=""first""";
10063 + else;
10064 + done;
10065 +
10066 + done;
10067 + done;
10068 + end;
10069 +


Tagset Error.jpg
Super User
Posts: 19,059

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

That's weird. What version of SAS are you using? 

 

Try opening the TPL file and submitting it directly in SAS, the tpl file is a SAS program,  

New Contributor
Posts: 4

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Yes. I tried all 3 steps mentioned in the website. Still showing same
error.

##- Please type your reply above this line. Simple formatting, no
attachments. -##
SAS Super FREQ
Posts: 8,818

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Hi, when I went to here: http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html and downloaded the file in the Introduction section, it came down with a .SAS file extension. I submitted the code and did not get any errors.
cynthia
Super User
Posts: 7,405

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

[ Edited ]

Check the file size after download and copying. It should have 34682 bytes.

The md5 checksum (if you can calculate it) is 1d4eb1f569938765df4b1d61a638d7c8

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 7,405

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Start a fresh session and re-submit the code (with only the include!).

The log should not have more than ~1200 lines. The fact that your log is already at 10000+ shows that some other code has run that might have done something bad.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Hi,
I'm working on WPS not SAS. Will there be any problem because of this?

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Regards
Thiruvanan T.
Super User
Posts: 19,059

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Yes, the templates are not designed for WPS and may not work. I suggest you contact WPS support and get their response. 

Super User
Posts: 7,405

Re: Issue with Tagset MSOffice2K_x (Error while submitting)


thiruvanan wrote:
Hi,
I'm working on WPS not SAS. Will there be any problem because of this?




Hrmph. ROFLMAO.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 19,059

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

@KurtBremser To be fair, SAS is prohibitively expensive for an individual consultant. WPS is a fraction of the cost if you're just starting out. I have a WPS license for my consulting, because there's no way I can afford a SAS license with one or two small clients a year. At work I have full access to SAS.

New Contributor
Posts: 4

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

@Reeza, Can you please tell me by submitting this code in WPS, if possible?
Just to get confirmed if it's because of WPS. Thanks again for the reply.

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Regards
Thiruvanan T.
Super User
Posts: 7,405

Re: Issue with Tagset MSOffice2K_x (Error while submitting)


Reeza wrote:

@KurtBremser To be fair, SAS is prohibitively expensive for an individual consultant. WPS is a fraction of the cost if you're just starting out. I have a WPS license for my consulting, because there's no way I can afford a SAS license with one or two small clients a year. At work I have full access to SAS.


The proper path would now be to contact WPS technical support and provide them with the SAS code that doesn't work on their platform, but works OK in its native environment.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 11 replies
  • 329 views
  • 4 likes
  • 4 in conversation