CSPro 3.0.005 27 Mar 2006 Release Notes ============= This document contains the following sections: [0] Updates Since Initial Release [1] What's New in CSPro 3.0 [2] Migrating Applications from CSPro 2.6 to 3.0 [3] CSPro 3.0 List of Modules [4] Hardware and Software Requirements [5] Example Files and Folders [6] What was New in CSPro 2.6 [7] What was New in CSPro 2.5 [8] What was New in CSPro 2.4 [9] What was New in CSPro 2.3 [10] What was New in CSPro 2.2 ============================================================================ [0] Updates Since Initial Release CSPro 3.0 Development Release History ------------------------------ 30 Nov 2005 - 3.0.001 Initial release 08 Dec 2005 - 3.0.002 Update release 16 Dec 2005 - 3.0.003 Update release 20 Jan 2006 - 3.0.004 Update release 27 Mar 2006 - 3.0.005 Update release Data Dictionary =============== 27 Mar 2006 - Generate value set no longer crashes when interval is and value label template contains %s twice. Data Entry ========== 08 Dec 2005 - When a 2nd data file is opened in data entry, the notes file is now correctly attached. Data entry no longer crashes when a repeating item with subitems is used. 20 Jan 2006 - The F7 key now works correctly in data entry. 27 Mar 2006 - The keyboard shortcut for full screen (Ctrl+J) works correctly even when not adding,verifying or modifying data. Data Entry Designer =================== 16 Dec 2005 - Error message when adding a form to an application that has an existing form with no fields is improved. 08 Dec 2005 - Column widths in rosters are now correct when rosters are in right to left (Arabic) mode. Join and Split now work correctly when rosters are in right to left (Arabic) mode. Frame containing roster now start at right side when rosters are in right to left (Arabic) mode. 27 Mar 2006 - Can now set the properties of the last column in a roster. Batch Edit ========== 08 Dec 2005 - Run Batch Edit now correctly accepts existing external file names. 16 Dec 2005 - Using the sum, min, max, and average function with a where clause no longer causes subscript errors in cases where it should not. CSPro Language ============== 08 Dec 2005 - The use of SUM, MIN, MAX, and AVERAGE functions no longer cause CSPro to crash. 20 Jan 2006 - The FILEWRITE function now allows file names such as: C:\file name\name of file to be output. Tabulation ========== 16 Dec 2005 - The use of mean, standard deviation and variance when combined with area processing in a table no longer causes a crash. Table titles with custom text are correctly displayed in tables tree, the goto dialog in print preview and the height of the title row is correct for table titles with custom text. 20 Jan 2006 - Tabulation now ignors SET OLD_TBD = Y. Tablation now reads data files on CD ROMS. Custom tabulation of special values are now works correctly. Tabulation Designer =================== 20 Jan 2006 - Value set changed message now only occurs once. When Tally Attributes (variable) dialog is closed percent only selection and when percents None now gives an error message. When multiple relations are available in the data dictionary, all the relations are now available as possible units of tabulation. Format Application dialog now lets you change the text for the word AND. Print preview of tables that span several horizontal pages now works correctly. 27 Mar 2006 - Print preview correctly displays data cells when captions are set to span fields. Save as works correctly for tabulation applications which use nonstandard names for the working storage dictionary. Text Viewer =========== 20 Jan 2006 - Text Viewer now reads text on CD ROMS. Table Viewer ============ 08 Dec 2005 - Area names now display when they occur in the field area of the table. Tables that have crossed varables in the columns (A*B), contain hidden columns, and span more that one horizontal page are now printed correctly. 20 Jan 2006 - Table Viewer now reads tables on CD ROMS. Table Retrieval Setup ====================== 16 Dec 2005 - Table titles read in from a TBW file are correct when the title uses custom text. 20 Jan 2006 - A better error message is now given when you attempt to load a TBW file that does not have area breaks. Table Retrieval =============== 20 Jan 2006 - Table Retrieval now reads data from CD ROMs. Documentation ============= 08 Dec 2005 - Missing pages of documentation have been completed. Help is now available for file associate dialog box in tabulation. 20 Jan 2006 - References in PFF file documentation to CSPro 2.5 have been changed to CSPro 3.0. Documentation of the EDITNOTE function has been corrected. Documentation of the WRITEFILE function has been changed. 27 Mar 2007 - Tips and Tricks section added to Tabulation documentation. Index entries updated for Tabulation documentation. Various corrections and minor additions to Tabulation documentation. ============================================================================ [1] What's New in CSPro 3.0 Those of you who are already familiar with CSPro 2.6 should note the following significant changes and new features. Please refer to the CSPro documentation or on-line helps for more information. CSPro ===== - On launch CSPro allows you to select a recently used application to open. - You can save a copy of an application under a different name. - The New wizard has been improved to make the creation of new applications easier. Tabulation ========== - You can add and cross variables in the rows and columns of a table. - You now have control over the presence of totals and their position. - You now have control over position of percents in tables. - You can produce statistics (min, max, mean, median, mode, std. dev., variance, n-tiles) for any variable in the table. - You can different units of tabulation in the same table. - a full arithemetic expression in the CSPro language can be used to define the tally value and/or weight used in tabulation - A full conditional expression in the CSPro language can be used to define the universe of a table. - You now have full formatting control over are the text in the tables. - You can draw borders around any element of your table. - You save and load you own standard formatting preferences to be used by default in all the table you design. - You can design tables which span facing pages in a printed publication. - Stubs are supported on both the left and right sides of a table. - Full area processing like that available in IMPS is now available. - Zero can be used as a valid area code value. Dictionary ========== - You can now generate value sets using specified ranges and a value set label template. - You can now define multiple items within multiple records in CSPro. CSPro Language ============== - Subscipting of multiple items within multiple records is supported. Tabulate Frequencies ==================== - Full conditional expression for universe - Weighted frequencies - Frequency by value set or by each value found - Statistics (Min, max, mean, std. dev., variance, mode, median) Table Viewer ============ - The Table Viewer allows you to change the formatting of saved tables. - You can hide rows or columns in tables you are viewing. ============================================================================ [2] Migrating Applications from CSPro 2.6 to 3.0 You cannot use a CSPro 2.x Cross Tabulation application in CSPro 3.0. You must create a new CSPro 3.0 Tabulation appication. However, you can use your CSPro 2.x dictionaries for CSPro 3.0 Tabulation applications. All other applications and tools from CSPro 2.x will work in CSPro 3.0. ============================================================================ [3] CSPro 3.0 List of Modules The following modules are located in the "\Program Files\CSPro 3.0" folder; module names are followed in parentheses by their Windows executable file name: Data Dictionary (CSPro.exe) Data Entry Designer (CSPro.exe) Batch Edit Designer (CSPro.exe) Tabulation Designer (CSPro.exe) Data Entry Run (CSEntry.exe) Batch Edit Run (CSBatch.exe) Tabulation Run (CSTab.exe) Consolidation Run (CSCon.exe) Calculation Run (CSCalc.exe) Text Viewer (TextView.exe) Table Viewer (TblView.exe) Map Viewer (MapView.exe) Table Retrieval (TRSWin.exe) Tabulate Frequencies (CSFreq.exe) Sort Data (CSSort.exe) Export Data (CSExport.exe) Reformat Data (CSRefmt.exe) Compare Data (CSDiff.exe) Concatenate Data (CSConcat.exe) Table Retrieval Setup (TRSSetup.exe) Data Dictionary Converter (DDConvrt.exe) Shape to Map Converter (ShpToMap.exe) Pack Application (CSPack.exe) ============================================================================ [4] Hardware and Software Requirements A minimum configuration 33MHz 486 processor 16MB of RAM VGA monitor Mouse 45 MB of free hard drive Microsoft Windows 98SE A recommended configuration Pentium processor 256MB of RAM SVGA monitor Mouse 45 MB of free hard drive space Microsoft Windows 98SE, Me, NT 4.0, 2000, or XP ============================================================================ [5] Example Files and Folders The "\Program Files\CSPro 3.0\Examples" folder contains the following CSPro example files: Census 2000 Dictionary.dcf -- Census Data Dictionary example Census 2000 Data Entry.ent -- Census Data Entry example application Census 2000 National Tabs.xtb -- Census Tabulations -- National level Census 2000 Prov-Dist Tabs.xtb -- Census Tabulations -- Subnational levels Popstan Census 2000.dat -- Census data file for above applications Popstan Census 2000.anm -- Area Names file (Province/District) Popstan Census 2000.map -- Popstan map polygon file (ASCII) Popstan Census 2000.mpc -- Popstan map polygon file (binary) Popstan Census 2000.mdf -- Map data file for Map Viewer (ASCII) Popstan.trs -- TRS file for Table Retrieval Within the "\Program Files\CSPro 3.0\Examples" folder are the following CSPro example folders, each containing a self-contained CSPro application: Adding Weights (Batch Edit application) CAPI (Data Entry application) Computer Assisted Coding (Data Entry application) Create PFF File (Data Entry application) Current Population Survey (CrossTab application) DateCheck (Data Entry application) HotDeck (Batch Edit application) Impute (Batch Edit application) ItemDrivenDE (Data Entry application) LogFile (Data Dictionary) Lookup (Data Entry application) Selcase (Data Entry applicaiton) Two Level Application (Data Entry application) Write External File (Data Entry application) ============================================================================ [6] What's New in CSPro 2.6 Those of you who are already familiar with CSPro 2.5 should note the following significant changes and new features. Please refer to the CSPro documentation or on-line helps for more information. Data Dictionary =============== - RELATIONS. Relations provide a way of linking one multiple record or item to one or more other multiple records or items. Relations are defined in the data dictionary and can be used in FOR and EXPORT statements. CSPro (language) ================ - FILE declaration statement. This new statement defines files, not associated with dictionaries, that are used by the application and whose physical names are not given until run time. - RELATION declaration statement. This new statements defines relations for a particular application in addition to those defined in the data dictionary. - FILECONCAT function. This function concatenates a list of files. The list may contain individual files or wildcard file specifications. - FILECOPY function. This new function copies one file to another file. - FILECREATE function. This new function creates a new file with the given file name. If the file already exists, it is truncated to zero length. - FILEDELETE function. This new function deletes an already existing file from your system. - FILEEXIST function. This new function determines whether a file exists on your system. - FILENAME function modified. This function now return the full qualified name of a file defined by a file statement as well as a dictionary. - FILEREAD function. This function reads a text line from a file into an item or variable. - FILERENAME function. This new function changes the name of a file. - FILESIZE function. This new function returns the size of a file in bytes. - FILEWRITE function. This new function writes a line of text to a file. - EXECSYSTEM function. This new function starts another windows application or process. - MAXOCC function. This new function returns the maximum number of multiply occurring records or the maximum number of multiply-occurring items defined for a group in the dictionary. - SETFILE function. This new function assigns a new physical file to a dictionary or declared file and opens the file. - OPEN function modified. This function now opens a file defined by a file statement as well as defined by a dictionary. For files defined by a file statement, the file can be created or extended when opened. - CLOSE function modified. This function now closes a file defined by a file statement as well as defined by a dictionary. - FOR statement modified. This statement now allows relations to be used for looping. - SET BEHAVIOR EXPORT statement. This new statement determines the format output type of any subsequent Export statements. - EXPORT statement. This new statement writes a record to an export file defined by a file statement. Data Entry ========== - Improved handling of Arabic font text when entered into an alphanumeric data field. Export Data =========== - NEW INTERFACE. There a new interface for this tool. - RELATIONS. Records and items connected through a relation can be exported to the same record. - UNIVERSE. Particular cases, records, or items can be selected for export. - SINGLE FILE/MULTIPLE FILES. Export can be done to a single file or to multiple files. - SINGLE RECORD/MULTIPLE RECORDS Export of multiple records can be done to a single record or as separate records. - JOIN SINGLE AND MULTIPLE RECORDS. During export of multiple records as separate records, single records can be joined to each occurrence of the separate multiple records. - EXPORT RECORD TYPE. The record type of a record can be exported. - EXPORT RECORD ITEMS OR SUBITEMS. When an entire record is selected for export and subitems are contained in the record, only items, only subitems, or both items and subitems can be specified for output. - CSPRO AND SEMI-COLON DELIMITED OUTPUT. New output formats of CSPro and semi- colon delimited files are available. Table Retrieval Setup ===================== - NEW. This new tools allows you to create and edit a Table Retrieval file for use by the Table Retrieval tool. You can load a tables file generated by IMPS and individual files such as word processing documents, spreadsheets, or pdf files. ============================================================================ [7] What's New in CSPro 2.5 Those of you who are already familiar with CSPro 2.4 should note the following significant changes and new features. Please refer to the CSPro documentation or on-line helps for more information. CSPro (Data Entry Designer) =========================== - CAPI (Computer Assisted Personal Interviewing). In CAPI, the enumerator is presented a question to ask and enters the answers directly into CSPro. CSPro provide a switch to turn on CAPI behavior and a CAPI question editor. - CONTROL ITEM for ROSTER or MULTIPLE FORMS. An data item can now be specified to control the maximum number of occurrences of a roster or multiple form. - ROSTERS WITH FREE MOVEMENT. Roster now can either have their current behavior or can be made to behave as a spreadsheet where there is free movement Behavior in Rosters CSPro (language) ================ - BREAK and NEXT statements. These new statements allow you exit early from a loop and either exit the loop entirely or continue with the next iteration of the loop. - REENTER, SKIP, and ADVANCE statements. The statements have been enhanced to allow the specification of the target field in an alpha variable or data item. - MOVE statement. This new statement allows you to move to a field in data regardless on whether it is before or after the current field in the data entry sequence. - SYSPARM function. This new function allows you to retrieve the system parameter specified in the .PFF file which launched your application. - GETOPERATORID function. This new function allows you to retrieve the operator id entered by the operator or specified in the .PFF file which launched your data entry application. - GETSYMBOL function. This new function allows to retrieve the name of the proc which currently being executed. - GETLABEL function. This new function allows you to retrieve the data dictionary label associated with a dictionary, record, item, valueset or value. - HIGHLIGHTED function. This new function allows you to determine whether a field is on path during data entry in system controlled mode on before the high water mark in operator controlled mode. - SAVEPARTIAL function. This new function allows you save the current case partially under program control and continue with data entry. - ONSTOP global function. This new global function allows you to control events after a stop case is requested or data entry is closed while a case is being entered. - ONKEY global function. This new global funtion allows you capture and process each key press of the operator. - SET BEHAVIOR statement. This new statement allows you switch whether blanks are allowed in numeric fields. - SET ATTRIBUTES statement. This statement has been enhanced to specify whether a responses for a field are to be given for selection. The responses display are from the first value set in the data dictionary. Export Data =========== - SEPARATE RECORD EXPORT IN SPSS, SAS, and STATA. You can now export different records types to different files where multiple records in the indput file produce multiple records in the output files. This was available for text and comma delimited file previously and is now available for SPSS, SAS, and STATA exports. Pack Application ================ - NEW. This new tools allows you to create a zip file containing all the files that belong to an application. This is useful to transfer an application to another computer or to another colleague. ============================================================================ [8] What was New in CSPro 2.4 Those of you who are already familiar with CSPro 2.3 should note the following significant changes and new features. Please refer to the CSPro documentation or on-line helps for more information. CSPro (Data Entry Designer) =========================== - DATA ENTRY OPTIONS. You can allow partial saves of cases and show the case tree by selecting these options under the data entry options dialog box (Ctrl+E). CSPro (language) ================ - GETNOTE, PUTNOTE, EDITNOTE functions. These functions allow you to read and write notes to the notes file and force the operator to enter or read a note. They can only be coded in data entry applications. - MAKETEXT function. This function allow you to create a formatted string within your logic. - ONFOCUS and KILLFOCUS procedures. These procedures are only executed in data entry applications. They allow you to define statements which are always executed prior to and following entry of a level, roster, or field. CSEntry (Data Entry Module) =========================== - You can now save notes which are associated with a particular field within a particular case. - A case can now be partially saved in Add, Modify, or Verify mode. When this feature is turned on, you can stop anytime during the entry of a case and come back to it later. You will have the choice of beginning at the position in the case where you left off, or at the first keyable field of the case. - A case tree has been added for navigation within a case. When this feature is turned on, a tree showing the names and values of data items within the case is displayed. It can be used for moving between data items or for examining what has been entered in the case. - The menus and keyboard shortcuts have been changed and augmented. In particular, the Functions menu item has been split into Edit and Navigation menus. Additional items have been added to the View menu. CSPro (all modules) =================== - BACKWARD COMPATIBILITY. You can open any application created in CSPro 2.2 or 2.3 in CSPro 2.4. ============================================================================ [9] What was New in CSPro 2.3 Those of you who are already familiar with CSPro 2.2 should note the following significant changes and new features. Please refer to the CSPro documentation or on-line helps for more information. CSPro (Data Entry Designer) =========================== - COLOR IN FORMS. You now have total control over the colors you use in your data entry applications. Each form can have its own color, and every text item can have its own color. - MORE ALIGNMENT FUNCTIONS FOR FORMS DESIGN. In addition to aligning things left, right, top and bottom, you can now center things and space them evenly. CONCATENATE DATA UTILITY ======================== - This utility allows you to concatenate (join together) as many data files (or text files) as you like. The data files can be from any folder and you can sort them in a variety of ways. You'll find it on CSPro's Tools menu. CSPro (language) ================ - INSERT/DELETE/SORT COMMANDS. These are new commands in the CSPro language, which provide you more power in manipulating your data files. - DECLARING VARIABLES IN YOUR LOGIC. Variables that are not declared in PROC GLOBAL will be flagged as errors to help you avoid unintentional errors in your logic. If you prefer, you can easily set the compiler not to flag these as errors, as in CSPro 2.2. See the CSPro documentation on "Declarations" for more details. - SUBSCRIPT CHECKING. The CSPro compiler now issues warnings for unusual or improper use of subscripts. This will help you find errors in your logic, avoid run-time errors, and help ensure that your applications work the way you want. - REENGINEERED EXECUTION MODULES. We've done a lot of work "under the hood" to improve the way CSPro runs your applications. Several small bugs have been fixed and unusual behaviors corrected. CSPro (all modules) =================== - MORE PRODUCTION SUPPORT. We've standardized the Run Information files (.PFF) and provided more options for you to control the way CSPro data applications run. You can now double click on any .PFF file and CSPro will execute it. - BACKWARD COMPATIBILITY. You can open any application created in CSPro 2.2 and run it in CSPro 2.3. However, there are some differences between 2.2 and 2.3 that might affect the way your applications run. You may need to make some small modifications to your applications to make then run properly in 2.3. See the next section on "Migrating applications from CSPro 2.2 to 2.3" for more details. ============================================================================ [10] What was New in CSPro 2.2 Installation ============ - Support for installing and changing language used for minimum language features. CSPro (all modules) =================== - Minimal language support. Default small words in Tables and Maps are available in Armenian, English, French, Spanish, Portuguese, Russian, and Ukrainian. The Armenian, Russian, and Ukrainian alphabets are supported. - Toggle (Ctrl+U) between full screen (no tree) or split screen (with tree). - Toolbar buttons to change between the dictionary, data entry forms, batch edit code, and cross tabulations. - Tool tips work thoughout CSPro. CSPro (Data Dictionary) ======================= - Save dictionary under a different file name (Save As). CSPro (Data Entry Designer) =========================== - Better reconcilation of CSPro data entry applications with changes in the data dictionary. - Cut, Copy, and Paste objects while designing forms. - Create operator directed skips under field properties. - Specify force out-of-range, upper case alpha, and verify at the individual field level. Specify verification of every nth case. CSPro (Edit Designer) ===================== - Better reconciliation of CSPro edit applications with changes in the data dictionary. Option to specify dictionary or custom order of edits. CSPro (Cross Tabulation) ======================== - Option to show or not show area tables where no tallies occurred. - Apply a universe definition to ALL tables by pressing the "Apply to All Tables" button in the universe dialog box. CSPro (Language) ================ - Tooltips displayed when entering function names in code. Data Entry ========== - Can change the order cases are listed between entry order and case id sort order. - Can use + key on numeric pad to perform operator directed skip. - Can set full screen mode and initialize persistent fields in .PFF file. - Can perform interactive edits in modify mode using F11. - Verification of only selected fields. - Verification of every nth case. Text Viewer =========== - Option to show DOS Line Draw characters (OEM) rather than Windows characters (ANSI). Tabulate Frequencies ==================== - Toggle (Ctrl+T) between labels and names in the dictionary tree. - Select a universe for frequencies. Sort Data ========= - Sort by records within questionnaires. - Sort by quesetionnaires using non-id items. Export Data =========== - Toggle (Ctrl+T) between labels and names in the dictionary tree. Whatever text (labels or names) that appears in the tree will be the header row in the file. - Export single as well as multiple output files. - Select a specific occurrence of a subitem of a multiply occurring data item. Reformat Data ============= - More information provided about differences between dictionaries. - Can move items from a single record to another single or a mulitiple record. Compare Data ============ - New Tool to compare two data files and list the differences. ============================================================================ Comments, questions, and suggestions should be addressed to: Methodology & Software Development Branch International Programs Center U.S. Census Bureau Washington, DC 20233-8860 USA Phone: 1 (301) 763-1451 Fax: 1 (301) 457-3033 E-mail: CSPro@lists.census.gov Web site: www.census.gov/ipc/www/cspro