9/16/2002 Update Announcement (read the ReadMe first!) contents of SASProfileCodeSep13.zip Name Modified Size Ratio Packed MainSF3.sas 9/13/2002 4:45 PM 16,009 61% 6,275 PageTOC.sas 9/13/2002 4:23 PM 9,646 70% 2,870 Disprof.sas 9/11/2002 4:55 PM 68,103 81% 12,608 PrimeProf.sas 9/11/2002 4:53 PM 100,217 77% 22,703 subsets.sas 8/30/2002 6:09 PM 1,578 60% 628 Povprof.sas 8/30/2002 12:45 PM 89,007 80% 17,789 LangProf.sas 8/27/2002 4:58 PM 25,299 75% 6,221 formats.sas7bcat 8/22/2002 10:53 AM 431,104 82% 75,565 HousProf.sas 8/14/2002 2:48 PM 43,704 75% 10,901 sumlev.sas 8/13/2002 5:23 PM 5,151 78% 1,129 county.sas 8/13/2002 5:22 PM 107,322 74% 28,084 Geocomp.sas 8/13/2002 5:21 PM 9,368 88% 1,159 Geocompbrief.sas 8/13/2002 5:11 PM 5,525 81% 1,026 JobsProf.sas 8/12/2002 5:52 PM 25,985 81% 4,955 tranprof.sas 8/12/2002 12:55 PM 19,218 75% 4,872 EducProf.sas 8/ 6/2002 3:01 PM 13,355 75% 3,389 IncProf.sas 8/ 2/2002 6:03 PM 40,782 81% 7,874 AncyProf.sas 8/ 2/2002 5:26 PM 20,992 76% 4,950 familyprof.sas 7/25/2002 7:37 PM 9,840 77% 2,278 migrprof.sas 7/25/2002 7:30 PM 16,273 77% 3,724 secprof.sas 7/25/2002 6:30 PM 43,045 77% 9,720 SF3Template.sas 7/15/2002 3:49 PM 1,227 57% 529 CalcMedian.sas 4/ 5/2002 12:26 PM 3,722 59% 1,508 23 file(s) 1,106,472 79% 230,757 Major addition to the package: Profile set now (optionally) begins with a Table of Contents listing all the page titles and indicating which modules and pages were selected. Depending on the setting of the ToC parameter, the Table of Contents is included at the beginning of every profile, or only once at the beginnning of a run, or is suppressed entirely. Minor improvements and fixes: The %Include's in MainSF3 now have the correct upper & lower-case file names (relevant for UNIX users only.) Division by zero is now tested in DisProf; a space added to two table titles. Lines longer than 200 characters in DisProf were split by John Blodgett to avoid truncation warning messages. As far as we know this wasn't causing errors, but we don't want to ignore warning messages. (Thanks for fixing this, John.) Mean income deficit in PovProf now tested for division by zero (Thanks, Sen-Yuan Wu, NJ SDC) Typo in a comment fixed in PrimeProf. Line of asterisks with no semi-colon (unclosed comment) removed from the end of LangProf. Minor addition to the package: Tiny file "subsets.sas" illustrates chopping the huge data sets into faster- running extract files. MainSF3 now has these extract files (commented out) as alternatives to the MERGE of the big files. Additional user experiences: At least two users of the package discovered that in order to get appropriate page breaks they had to modify the final PUT statement (in the HeadFoot routine at the end of MainSF3) so that it creates 65 lines per page instead of 64. John Blodgett in MO, running under Unix, is using the extra line to report the profile's file name on his Web server, and Yi Zhao in WA, running under Windows, has moved the date and page number to the 65th line. John also discovered that ODS PDF works for him. In his environment he is able to bypass the step of distilling the PostScript output to pdf. Here at MISER the output from ODS PDF has spacing problems--the columns of numbers don't line up correctly. --- rew/Sept16 -------------------------------------------------------------------------- 8/14/2002 previous Update Announcement (read the ReadMe first!) contents of SASProfileCodeAug14.zip Name Modified Size Ratio Packed MainSF3.sas 8/14/2002 6:56PM 14,603 60% 5,770 Titles.txt 8/14/2002 5:55PM 5,000 68% 1,607 formats.sas7bcat 8/14/2002 5:53PM 431,104 82% 75,560 PrimeProf.sas 8/14/2002 5:12PM 100,218 77% 22,699 Povprof.sas 8/14/2002 3:04PM 88,705 80% 17,705 HousProf.sas 8/14/2002 2:48PM 43,704 75% 10,901 sumlev.sas 8/13/2002 5:23PM 5,151 78% 1,129 county.sas 8/13/2002 5:22PM 107,322 74% 28,084 Geocomp.sas 8/13/2002 5:21PM 9,368 88% 1,159 Geocompbrief.sas 8/13/2002 5:11PM 5,525 81% 1,026 JobsProf.sas 8/12/2002 5:52PM 25,985 81% 4,955 tranprof.sas 8/12/2002 12:55PM 19,218 75% 4,872 Disprof.sas 8/ 8/2002 2:58PM 70,670 82% 12,731 LangProf.sas 8/ 6/2002 7:06PM 25,283 76% 6,181 EducProf.sas 8/ 6/2002 3:01PM 13,355 75% 3,389 IncProf.sas 8/ 2/2002 6:03PM 40,782 81% 7,874 AncyProf.sas 8/ 2/2002 5:26PM 20,992 76% 4,950 familyprof.sas 7/25/2002 7:37PM 9,840 77% 2,278 migrprof.sas 7/25/2002 7:30PM 16,273 77% 3,724 secprof.sas 7/25/2002 6:30PM 43,045 77% 9,720 SF3Template.sas 7/15/2002 3:49PM 1,227 57% 529 CalcMedian.sas 4/ 5/2002 12:26PM 3,722 59% 1,508 22 files 1,101,092 79% 228,351 Important correction (this one was major, affecting whole first column): Totals column, bottom panel of Poverty page-8 was calculated using invalid variables Minor improvements: MainSF3 & Primary now allow lower-case in profile & page selection parameters. Fuller documentation in MainSF3. MainSF3 now has an explicit ProcFormat run (commented out--users should run once). Minor additions to package: (1) Text file "Titles.txt" with the page titles for all 58 pages. Print it out as a reference. Eventually this will become the nucleus of a Table of Contents page which will be (optionally) part of every profile. (2) SAS formats catalog "formats.sas7bcat" which may save Windows users the few minutes it takes to run Proc Format once, but probably is not compatible with other platforms. --- rew/Aug 14 --------------------------------------------------------------------------------------- 8/13/2002 previous Update Announcement (read the ReadMe first!) contents of SASProfileCodeAug13.zip Name Modified Size Ratio Packed sumlev.sas 8/13/2002 5:23PM 5,151 78% 1,129 county.sas 8/13/2002 5:22PM 107,322 74% 28,084 Geocomp.sas 8/13/2002 5:21PM 9,368 88% 1,159 Geocompbrief.sas 8/13/2002 5:11PM 5,525 81% 1,026 HousProf.sas 8/13/2002 4:56PM 43,656 75% 10,894 JobsProf.sas 8/12/2002 5:52PM 25,985 81% 4,955 Povprof.sas 8/12/2002 5:25PM 88,542 80% 17,665 tranprof.sas 8/12/2002 12:55PM 19,218 75% 4,872 MainSF3.sas 8/8/2002 3:17PM 12,766 60% 5,135 Disprof.sas 8/8/2002 2:58PM 70,670 82% 12,731 PrimeProf.sas 8/6/2002 10:04PM 100,214 77% 22,693 LangProf.sas 8/6/2002 7:06PM 25,283 76% 6,181 EducProf.sas 8/6/2002 3:01PM 13,355 75% 3,389 IncProf.sas 8/2/2002 6:03PM 40,782 81% 7,874 AncyProf.sas 8/2/2002 5:26PM 20,992 76% 4,950 familyprof.sas 7/25/2002 7:37PM 9,840 77% 2,278 migrprof.sas 7/25/2002 7:30PM 16,273 77% 3,724 secprof.sas 7/25/2002 6:30PM 43,045 77% 9,720 SF3Template.sas 7/15/2002 3:49PM 1,227 57% 529 CalcMedian.sas 4/5/2002 12:26PM 3,722 59% 1,508 20 files 662,936 77% 150,496 One actual correction: two totals on the first page of the Jobs profile were using the wrong variables. Minor improvements: Possible division by zero is now checked in Poverty & Transportation. (Eliminates possibility of warning notes in the log.) One header line clarified in Housing-2 The four formats (sumlev.sas, county.sas, Geocomp.sas, & Geocompbrief.sas) now contain only the VALUE statement, with a comment saying to bracket with a PROC FORMAT LIBRARY=LIBRARY statement and RUN statement. rew/Aug13