topic Re: Is there anything wrong with my script? in ODS and Base Reporting

Is there anything wrong with my script?

Yennie — Tue, 09 Feb 2010 01:34:43 GMT

Hey all...

I have written this piece of code to create a frameset for my html pages... however the frame page is showing up as a blank page...

%Let dir = \\int\Collaborate\PI\Portfoli\PI-Pricing\Risk & Operations\Asset Risk\PROJECTS\VOR Monthly Report Tool\HTML;
%Let frameset = gio_frame.html;
%Let leftframe = gio_inforce_leftframe.html;
%Let righttopframe = rightf_all.html;
Filename gioframe "&dir\&frameset";
Data _Null_;
File gioframe;
Put '';
Put '';
Put '';
Put '';
Put '';
Put '';
Put '';
Put '';
Put '';
Run;

does anyone know the reason why it's blank?

cheers
yennie

Re: Is there anything wrong with my script?

Yennie — Tue, 09 Feb 2010 01:36:34 GMT

and i forgot to mention it's
%Let output = results.html;

cheers,
yennie

Re: Is there anything wrong with my script?

sbb — Tue, 09 Feb 2010 02:35:03 GMT

With your SAS code, I expect you are getting some type of SAS execution/compilation error, which would be most useful to share.

You will likely find the problem having to do with using quoted-strings and macro variables. A PUT statement will not resolve a macro variable when used with a single-quoted literal. So you need to use double-quotes but since the HTML tag syntax also requires quotes, you must duplicate your quote character for each instance where you want a double-quote to be generated, such as:

1 %let my_quote = Yes, The New Orleans Saints won the Super Bowl!;
2 data _null_;
3 putlog "Hello - I say to you all: " /// """&my_quote""";
4 run;

Hello - I say to you all:

"Yes, The New Orleans Saints won the Super Bowl!"
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

using macro variables quoted strings site:sas.com

Re: Is there anything wrong with my script?

Yennie — Tue, 09 Feb 2010 04:02:37 GMT

Hey scott,

thanks heaps. amended my script to something like that and works well 🙂

%Let dir = \\int\Collaborate\PI\Portfoli\PI-Pricing\Risk & Operations\Asset Risk\PROJECTS\VOR Monthly Report Tool\HTML\;
%Let frameset = gio_frame.html;
%Let leftframe = gio_inforce_leftframe.html;
%Let righttopframe = rightf_all.html;
%Let output = results.html;

Filename gioframe "&dir&frameset";
Data _Null_;
File gioframe;
Put '';
Put "";
Put '';
Put "";
Put "";
Put '';
Put '';
Run;