DATA WORK.CustomTaskBookStats;
    LENGTH
        number_of_words    8
        total_editing_time   8
        revision_number    8
        creation_date      8
        path             $ 48
        last_save_time     8 ;
    LABEL
        number_of_words  = "Number of words"
        total_editing_time = "Total Editing Time"
        revision_number  = "Revision Number"
        creation_date    = "Creation Date"
        path             = "Path"
        last_save_time   = "Last Save Time" ;
    FORMAT
        number_of_words  BEST4.
        total_editing_time BEST4.
        revision_number  BEST2.
        creation_date    DATETIME21.2
        path             $CHAR48.
        last_save_time   DATETIME21.2 ;
    INFORMAT
        number_of_words  BEST4.
        total_editing_time BEST4.
        revision_number  BEST2.
        creation_date    DATETIME21.
        path             $CHAR48.
        last_save_time   DATETIME21. ;
    INFILE DATALINES4
        DLM=','
        MISSOVER
        DSD ;
    INPUT
        number_of_words  : ?? BEST4.
        total_editing_time : ?? BEST4.
        revision_number  : ?? BEST2.
        creation_date    : ?? ANYDTDTM22.
        path             : $CHAR48.
        last_save_time   : ?? ANYDTDTM21. ;
DATALINES4;
4501,1221,37,1/27/2008 3:31:00 PM,Chap01_WhyCustomTasks.docx,7/21/2012 11:38:00 AM
3585,821,40,2/9/2008 2:29:00 PM,Chap02_ToolsOfTheTrade.docx,7/23/2012 8:17:00 PM
2855,271,20,8/16/2008 11:53:00 AM,Chap03_CreatingTaskProjectsWithVisualStudio.docx,7/21/2012 12:02:00 PM
4736,623,21,5/31/2009 2:51:00 PM,Chap04_MeetTheAPIs.docx,7/21/2012 12:25:00 PM
4029,578,26,6/26/2010 12:58:00 PM,Chap05_MeetTheTaskToolkit.docx,7/21/2012 12:46:00 PM
3316,92,13,1/3/2009 2:21:00 PM,Chap06_FirstCustomTaskVB.docx,8/5/2012 2:22:00 PM
3338,295,27,1/3/2009 1:35:00 PM,Chap07_FirstCustomTaskCSharp.docx,8/5/2012 2:22:00 PM
6674,800,39,12/30/2011 4:43:00 PM,Chap08_DebuggingTechniques.docx,8/5/2012 3:28:00 PM
3037,432,24,1/22/2008 9:45:00 PM,Chap09_TopN.docx,8/5/2012 3:54:00 PM
2507,473,17,3/6/2011 5:58:00 PM,Chap10_TaskPropertyViewer.docx,8/5/2012 4:09:00 PM
5672,1073,42,3/6/2011 5:38:00 PM,Chap11_CalculatingRunningTotals.docx,9/11/2012 3:03:00 PM
2830,472,26,9/30/2008 8:48:00 PM,Chap12_DataToDataStep.docx,8/5/2012 4:28:00 PM
3747,513,15,3/6/2011 5:46:00 PM,Chap13_CompressSASData.docx,8/5/2012 4:42:00 PM
2267,338,15,2/28/2011 6:40:00 PM,Chap14_SystemCommand.docx,8/5/2012 4:47:00 PM
4452,1125,26,12/29/2010 12:36:00 PM,Chap15_FacebookFriends.docx,9/19/2012 10:06:00 PM
3246,544,27,3/6/2011 5:49:00 PM,Chap16_SASCatalogExplorer.docx,8/5/2012 5:30:00 PM
5139,901,19,9/22/2012 1:54:00 PM,Chap17_MacroVariableViewer.docx,9/29/2012 11:33:00 AM
;;;;

title "Chapter file characteristics";
proc print data=work.customtaskbookstats;
var path creation_date last_save_time revision_number number_of_words total_editing_time;
run;

proc sql;
  create table range as select
    'WRITING PERIOD' as range length=20,
    min(creation_date) as start_date format=dtdate9.,
	  max(last_save_time) as end_date format=dtdate9.
	from work.customtaskbookstats;
quit;
title "Date ranges of Chapter editing";
proc print data=range;
run;
title "Statistics for Words and Editing Time";
proc means data=work.customtaskbookstats sum min max;
var number_of_words revision_number total_editing_time;
run;
title;