/***************************************************************************/
42         ods excel options(
43         	sheet_name = 'Termed_Providers_Detail'
44         	embedded_titles='yes'
2                                                          The SAS System                                10:10 Friday, June 16, 2017

45         	EMBEDDED_FOOTNOTES= 'Yes'
46         	sheet_interval="table"
47         	frozen_headers='1'
48         	orientation='landscape'
49             );
50         RUN;
51         %let footnote2=;
52         data to_report ;
53           if _n_=1 and eof then do;
54             call symputx('footnote2','No data to report');
55             output;
56           end;
57           set detail3 end=eof;
58         run;

NOTE: There were 0 observations read from the data set WORK.DETAIL3.
NOTE: The data set WORK.TO_REPORT has 1 observations and 13 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds
      

59         
60         PROC REPORT DATA=Detail3;
61          COLUMN Member_ID Member_Effective_Date Provider_ID Provider_Name COUNTY Provider_Term_Date Par_Non_Par;
62            title " LOB 1300 Termed Provider Report Detail " ;
63            compute after _page_ / left;
64               line "&footnote2" ;
65             endcomp;
66            title " LOB 1300 Termed Provider Report Detail " ;
67         footnote" Run at &sDay &stime";
68         RUN;

NOTE: No observations in data set WORK.DETAIL3.
NOTE: No observations in input data set.
NOTE: PROCEDURE REPORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

69         
70         ods _all_ close;
NOTE: ODS PDF(EGPDF) printed 25 pages to /sas/work01/SAS_work9158000015D5_phlprlxsascn005.kmhp.com/#LN00376.
NOTE: Writing EXCEL file: 
      /mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/LOB_1300_PP/Enrollment/Termed_Providers/2017/Termed_Providers_0616-2017.xls
      x
71         
72         
73         
74         
75         
76         
77         GOPTIONS NOACCESSIBLE;
78         %LET _CLIENTTASKLABEL=;
79         %LET _CLIENTPROJECTPATH=;
80         %LET _CLIENTPROJECTNAME=;
81         %LET _SASPROGRAMFILE=;
82         
3                                                          The SAS System                                10:10 Friday, June 16, 2017

83         ;*';*";*/;quit;run;
84         ODS _ALL_ CLOSE;
85         
86         
87         QUIT; RUN;
88