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 +
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,
Check the file size after download and copying. It should have 34682 bytes.
The md5 checksum (if you can calculate it) is 1d4eb1f569938765df4b1d61a638d7c8
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.
Yes, the templates are not designed for WPS and may not work. I suggest you contact WPS support and get their response.
@thiruvanan wrote:
Hi,
I'm working on WPS not SAS. Will there be any problem because of this?
Hrmph. ROFLMAO.
@Kurt_Bremser 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.
@Reeza wrote:
@Kurt_Bremser 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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.