I have a SAS program that produces a summary report that calculates the average
days it takes for investigators to complete their investigation. This report is
grouped by Investigator name and the investigator name is a hyperlink that should
drill down to the details of that summary record for that investigator. Right now I am branching to a different part(ods html body=invdrilldown.html) of the same SAS program when the hyperlink is clicked to produce the detail report. The problem I'm running into is when I click on the hyperlink(investigator name) on the summary report it tells me that html file for the detail report is not found (invdrilldown.html is not found). I have pasted parts of my program below.
Any help on this is greatly appreciated.
data InvLink;
set Investnm;
fmtname = "Invnmhr";
type = "C";
start = Investigator_Name;
label = "
"||trim(Investigator_Name)||"";
keep start label fmtname type;
run;
ods html body=sock (no_top_matter no_bottom_matter);
proc report data=temp ls=132 ps=40 nowd
column ('QA Report - Avarage Days To Complete Investigation' Investigator_Name Disease N No_of_days_toAddObs No_Of_Days_ToStartInv No_Of_Days_ToCompInv No_of_days_toComplPros);
define Investigator_Name/ format=$Invnmhr. group 'Investigator Name' ; define Disease / group 'Disease' ;
break after Investigator_Name / suppress page summarize style=[background=yellow font_weight=bold];
run;
ods html body=invdrilldown.html
proc report data=temp ls=132 ps=40 nowd
/*where Investigator_Name = Investigator_Name;*/
column ('QA Report - Avarage Days To Complete Investigation'Investigator_Name Disease N OBS_ID
Lab_Created_By Resulted_Test Dt_Recv_By_PH Lab_Create_Dt CAS_ID Patient_Name DtOB
Case_stat Jurisdiction MMWR_WEEK MMWR_YEAR Inv_Create_Dt NotificationDt No_of_days_toAddObs No_Of_Days_ToStartInv
No_Of_Days_ToCompInv No_of_days_toComplPros);
define Investigator_Name/ group 'Investigator Name' ;
define Disease / group 'Disease' ;
Thank You
Message was edited by: ALSAS