The SAS Output Delivery System and reporting techniques

Is there anything wrong with my script?

Reply
Frequent Contributor
Posts: 78

Is there anything wrong with my script?

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
Frequent Contributor
Posts: 78

Re: Is there anything wrong with my script?

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

cheers,
yennie
Super Contributor
Super Contributor
Posts: 3,174

Re: Is there anything wrong with my script?

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
Frequent Contributor
Posts: 78

Re: Is there anything wrong with my script?

Hey scott,

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

%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;
Ask a Question
Discussion stats
  • 3 replies
  • 125 views
  • 0 likes
  • 2 in conversation