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: 23,357

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Posted in reply to thiruvanan

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: 9,329

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Posted in reply to thiruvanan
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: 9,932

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

[ Edited ]
Posted in reply to thiruvanan

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
How to convert datasets to data steps
How to post code
Super User
Posts: 9,932

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Posted in reply to thiruvanan

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
How to convert datasets to data steps
How to post code
New Contributor
Posts: 4

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Posted in reply to KurtBremser
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: 23,357

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Posted in reply to thiruvanan

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: 9,932

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Posted in reply to thiruvanan

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
How to convert datasets to data steps
How to post code
Super User
Posts: 23,357

Re: Issue with Tagset MSOffice2K_x (Error while submitting)

Posted in reply to KurtBremser

@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: 9,932

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
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 11 replies
  • 366 views
  • 4 likes
  • 4 in conversation