Hi Everyone,
Firstly, I would like to apologise for failing to build this html page so many times. Maybe I did not explain myself really clear the past few weeks. For those who have helped and answered me out, really really thanks alot. So here it goes like this really...
I currently have three frames in MainFrame.html - FrameA(LeftFrame), FrameB and FrameC (Split Frame on the Right Frame) and the below codings for MainFrame.html...
Data _Null_;
File 'MainFrame.html';
Put '';
Put '';
Put '';
Put '';
Put '';
Put '';
Run;
Within FrameA.Html, there are 7 hyperlinks which link to FrameB.Html depending on what the user choose. Below shows the code and the designated html page that it will link to.
Title: Earnings
Type of Motorcycles - FrameB_CC.html
Type of Insurance Covers - FrameB_Cover.html
Age of Riders - FrameB_Riders.html
Type of Sales Channels - FrameB_Channels.html
States - FrameB_States.html
Age of Motorcycle - FrameB_VehAge.html
Make of Motorcycle - FrameB_Make.html
Now.. This is the tricky part with FrameB - which consists of two data fields that require users to key in the dates and also a select box depending on what the user chose in FrameA.Html. Say for example, If user selects "FrameB_States.html" , then the select options will be Queensland, Victoria, South Australia etc with an Optgroup name "States". Refer to below codings if "Type of Sales Channels" selected:
Data _Null_;
File 'FrameB_Channels.html';
Put 'Motor Insurance > GIO > Earnings > &FromFrameA'; - If "FrameB_Channels.html" been selected, Then &FromFrameA. will be reflected as "Type of Sales Channels" and of course if "Frame_States.Html" is selected then &FromFrameA. will be "States". Question 1: Does anyone know how to write this bit of script to get it reflected?
Put 'End of Month (E.g 912) : ';
Put 'Inforce Date (E.g 20JAN2010) : ';
Put 'Select the Type of Data to be Generated: ';
' '
' Agents '
' Branches '
' Brokers '
' Motor Dealers '
' Web Channel '
' Staff '
' Call Centre '; ---> If FrameB_Channels.html, the selections will look like this. However, if FrameB_States.Html is selected then the selections will be Victoria, Queeland, South Australia etc. Question 2: Does anyone know if this there is any script that can written to change the select group dynamically? Macro Script?
Put ' ';
Run;
Lastly FrameC.Html will outputs graphs and table of the selection made by user. And it goes like this...
ODS HTML Body = 'FrameC.html';
Data Results;
Set Data;
Where TypeofSalesChannel = "F"; ----> This part really depends on what the user select in FrameA.Html & FrameB.Html. Question 3: Does anyone know how to make this interacting with FrameA and FrameB.Html?
Run;
PROC SORT
DATA=Results OUT=Results;
BY TypeofSalesChannel ;
RUN;
PROC GPLOT DATA = Data_Smry NOCACHE;
PLOT Earnings * month /
GRID VAXIS=AXIS1 HAXIS=AXIS2 FRAME LEGEND=LEGEND1;
BY TypeofSalesChannel;
RUN;
ODS HTML Close;
Last Question: Is there anyway I can create a macro script without having to create a whole lots of different html pages? And I am strictly using SAS Base Code - not on SAS/Intrnet or Enterprise Guide. So hoping someone can direct me to something just using SAS Base Code!
cheers.
yennie
... View more
