CSPro 2.6.007 29 Sep 2005 Release Notes ============= This document contains the following sections: [0] Updates Since Initial Release [1] What's New in CSPro 2.6 [2] Migrating Applications from CSPro 2.5 to 2.6 [3] CSPro 2.6 List of Modules [4] Hardware and Software Requirements [5] Example Files and Folders [6] What was New in CSPro 2.5 [6] What was New in CSPro 2.4 [7] What was New in CSPro 2.3 [8] What was New in CSPro 2.2 ============================================================================ [0] Updates Since Initial Release CSPro 2.6 Development Release History ------------------------------ 13 Jun 2005 - 2.6.001 Initial release 15 Jun 2005 - 2.6.002 Update release 17 Jun 2005 - 2.6.003 Update release 24 Jun 2005 - 2.6.004 Update release 13 Jul 2005 - 2.6.005 Update release 09 Sep 2005 - 2.6.006 Update release 29 Sep 2005 - 2.6.007 Update release Data Dictionary =============== 29 Sep 2005 - Change an name and starting position of a dictionary item no longer crashes a data entry application. Data Entry Designer =================== 29 Sep 2005 - Change in dictionary which deletes all the items in a roster no longer causes a crash when the form is opened. Data Entry ========== 15 Jun 2005 - When Force Out-of-Range is Yes, CSPro now allows forcing of blanks in a field. 09 Sep 2005 - When using a single form or repeating form, CSPro now correctly clears form when movement between items is done by mouse clicks. Data Export =========== 17 Jun 2005 - When mutliple files are exported, the number of files names to be created is now asked for. When items from relations are selected, the selection is now saved properly. 09 Sep 2005 - Export asks for correct file names when exporting in SAS. CSPro Language ============== 24 Jun 2005 - Fileread and Filewrite statement now correctly open the files which they reference. 13 Jul 2005 - Stop statement within a do varying statement now works correctly. WriteCase no longer puts out a warning message 7099. 09 Sep 2005 - Break command now works correctly. SetFile statement with append now works correctly. Open and SetFile statements with external dictionary name and create now works correctly. Skip to next now works correctly after partial save. 29 Sep 2005 - Filewrite is no longer limited to a 255 character record. TRS Setup ========= 13 Jul 2005 - Defining UR at various area levels now works correctly. Documentation ============= 09 Sep 2005 - Documentation for the Open and Setfile statements has been corrected. ============================================================================ [1] 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. ============================================================================ [2] Migrating Applications from CSPro 2.5 to 2.6 If you have an existing CSPro 2.5 application which you plan to run using CSPro 2.6, you must take into consideration the following changes: TABLE RETRIEVAL Table Retrieval applications generated by Table Retrieval Setup in CSPro 2.6 cannot be used by the Table Retrieval tool in CSPro 2.5 or below. ============================================================================ [3] CSPro 2.6 List of Modules The following modules are located in the "\Program Files\CSPro 2.6" 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) Cross Tabulation (CSPro.exe) Data Entry Run (CSEntry.exe) Batch Edit Run (CSBatch.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 95 A recommended configuration Pentium processor 256MB of RAM SVGA monitor Mouse 45 MB of free hard drive space Microsoft Windows 98, Me, NT 4.0, 2000, or XP ============================================================================ [5] Example Files and Folders The "\Program Files\CSPro 2.6\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 2.5\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 was 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. ============================================================================ [7] 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. ============================================================================ [8] 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. ============================================================================ [9] 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