Manual for the Crosstabulation of CBMS Data using CSPro
Contents
1. Unit Tallied Default CORE_HPQ_MEM X value Tallied Weight Apply to All Tables Universe AGE _YR gt 15 and RELN 1 4 Apply to All Tables a Tab Logic Edit PostCalc Logic Edit Special values Use custom special values r Lowest Break Level col oe Here is the resulting table after applying the restriction to the universe Note that from the list earlier in VI A 8 in page 9 from 1 741 as the total population there are 341 persons who are aged 15 and above and household head CSPro 3 3 Core _HPQ xts File Edit View Tools Window Help D Shw ORS Ser x ba Seb Oe Table 1 Civil Status by Sex Core HPO Table 1 Civil Status by Sex Civil Status Table 2 Female Total 341 100 0 266 55 100 0 100 0 Single 18 S3 11 7 3 8 12 7 Married 282 82 7 261 21 91 3 38 2 Widow er 27 7 9 3 24 1 0 43 6 Divorced Separated 5 1 5 3 2 1 0 3 6 Common Law Live in g 2 6 5 1 2 8 1 8 Unknown P F Value Sets Value sets let you specify one or more group of values for a data item or subitem The resulting tables will contain row and column labels that correspond to the value labels or numeric distributions if no value label is present For example we want to classify ages of the population such as 0 5 6 12 13 16 17 and above Here are the steps 1 Expand the dictionary tree Select the item or variable we wish to add a value set In our example Age_yr 22. After clicking yes another window will appear In the Input data click the three dots found in the end and select the text file that contains the barangay municipal or province data that will be used in the table Then Select OK Define Tab File Associations lt Input Data gt lt Output TB gt EE C CBMSDatabase System Lrosstab Lore_HP _xtb tby Cancel Help Below is an example of created table for Civil Status and Sex CSPro 3 3 Core_HPQ xts File Edit View Tools Window Help aE ge D Shw OWS g EX 1 able 1 Civil Status by Sex Core_HPQ Table 1 Civil Status by Sex Sex Civil Status Female Total 1 741 878 B63 Single 1 012 546 466 Married 627 305 322 Widow er 63 10 53 Divorced Separated 13 5 8 Common Law Live in 25 12 13 Unknown B Percents Aside from numbers or magnitude cross tabulation enables us to show the distribution of values for an item as a percentage of either row or column totals or as a percentage of the table total There are optional percentages available for each value set in a table Tally attributes is used to create percentages To bring up the Tally Attributes 1 Right click on the variable in the table and choose Tally Attributes lt variable gt In this example select Tally Attributes Sex Table 1 Civil Status by Sex a Raa aaa Civil Status Female Tally Attributes Sex Total 1741 378 367 so Tally Attribute
3. 2 Second Method Click Start Click All Programs Search for CBMSDatabase and Click it Select HPQ Crosstab 290 Games Compute Control Panel Devices and Printers Default Programs Manual on Barangay Vendation Help and Support SU Manual on buiking the CEMS Datat A Manual on CBMS StatSimPro 50 ED StatSimPro 5 0 SU User s Manual for Building the CBM A User s Manual for Statistics Simulate i Chikke Messenger p CorelDRAW Graphics Suite X gt p Free PDF to Word Doc Converter 4 Bock CBMS B Cross tabulation Interface After opening a window such as below will appear C8Pro 4 4 Gore_HPtl ats l File Edt View Took Window Help lee ees Bex hae eS eee oe Coe nro Table 1 Relation to the HH Ta Loe HPU qarehorriee head H ce ld Ihe cam Peon Aecod l Fem Household Hec Relation t the HH head Te Liwe APU iung iaraa eiam Tatal Haad Witeyapoue SPO FUCA Lhe r son em denwo Lnupiber ir Erns Grandeon isranddaughter Fathen hother Dither Aelatnns ousercnaid boy Other eugene A a Dkt E Taks Hep press Fl C Getting to Know Cross tabulation CSPro 3 3 Core_HPQ xts ES File Edit View Tools Window Help ae oe aee SAVE RUN ADD TABLE DELETE DICTIONARY In the upper part of the crosstab window or toolbar there are shortcut icons that can be used Some commonly used shortcut icons 1 Fi Click this to Save the created table 2 G After c
4. Relation Name Primary Linked By Secondary CORE_HPG_MEM CORE_HP _SENIORCIT SENIORCIT_LINE 8 Click the OK button if all the relation properties are completely filled up Relation Specifications Add Insert Delete Relation Name Primary Linked By Secondary Linked By SCID CORE_HPQ_MEM MEMNO CORE_HPQ_SENIORCIT SENIORCIT_LINE Cancel Help 9 You are now ready to cross tabulate Household member with senior citizen ID by Sex Please note that the added item or variable is usually at the end of the dictionary tree under your chosen relation name Vil Saving and transferring Crosstab outputs A Save tabulations in several formats 1 To save all tables in the Crosstab application a Click Sa on the toolbar or from the File menu select Save Tables b If there is only one table in the Cross Tabulation application you will go directly to the Save As dialog c If your Cross Tabulation application has multiple tables defined within it a Select tables to save dialog box listing the tables is displayed Select tables to save Cancel Select All Help 18 B Va CBMS d Use the Select All button if all tables are needed Otherwise select the individual table s that you would like to save in a single Table Viewer file Multiple tables are selected in the usual manner with the Shift and or Ctrl keys e After selection press OK f Inthe Save As dialog box use the drop down Save as type menu to select the
5. Right click and select Add Value Set or select Modify Value Set to modify any existing value set 14 Mermber Record Line number Rel Hlembersumame Mernber first name Tat GH Relation to the HH referenc Other relationship He Sex val EE DOI mE Age it Modify Item Ctrl M s Bithi B Add Item ea L Eitht ge Insert Item Ins i Ce Bithl Sa Delete rat Bith oe Dit Em Birth F Add Value Set gi w Cii SS m Other Civil Status ai w Religion 3 Automatically it creates a new value set name shown in the right hand side It also requests some value set properties such as Value Set Label Value Label From To and Special Value Set Label Value Set Mame Value Label From To Special I Cen o a Age in years AGE YRS pM Core HPQ questionnaire 0 150 a Id tems cag Household Record ca Member Record Line number Member sumame Member first name Relation to the HH refereric Other relationship Ser Age in years Value Set Label A text label that describes an item or variable This cannot be left blank Value Set Name The name of this value for use in the CSPro language procedures Value Label A text label that appears in the table From The smallest value in the value set To The largest value in the value set Value Set Label Age in years Value Set Name Value Label AGE_YR_V3S1 To Special Core HPO a Ta Core HPO questionnaire 0 150 Id Items Age
6. window Note that the path of inputs and output are fixed that is each of the final encoded barangays is inputted and the output is now the text file of the municipality in the municipal directory Thus in general merging the barangays of a certain municipality shall have inputs C CBMSDatabase lt Regn gt lt Prov gt lt Mun gt lt Brgy gt lt Brgy txt gt And the output will be C CBMSDatabase lt Regn gt lt Prov gt lt Mun gt lt Mun txt gt QM AR CBMS lil Data Dictionary A Data Dictionary describes the overall organization of a data file It gives a description of how data are stored in a file Each dictionary will allow you to give text labels for all levels records items and value sets in the file It also allows you to describe the organization of each record in the file and the characteristics of each item in the record names position in the data record type of data length number of decimal places valid values and other documentation Data Dictionary Screen Lay out for the CSPro based encoding system CSPro 3 3 Core HPQ File Edit view Options Tools Window Help D ga Oe ei X i a E N Record Label Record Name Type Value Required Max Core HPO O Household Record CORE_HP _F 00 Yes 1 Si My Core HPO questionnaire Member Record CORE_HPQ_ 01 Yes 50 Id Items Wages Record CORE_HPQ_v02 No 50 m Household Record E Asset Record CORE_HPQ_ 03 No 1000 E oni aa E Crime Record COR
7. wv Item Values lt No Label Given gt 0 150 AGE_YR gt 15 OK Cancel Help 5 To enter several conditions use and or Add parentheses to modify the order of evaluation of the conditions Adding to the previous example aside from age the population was also restricted to contain data only for all household heads RELN 1 Edit Universe Dictionary Tree cm CORE_HPQ_MEM si Universe m MEMNO m MSNAME m MFNAME RELN m RELN_O m SEX m AGE_YR m AGE_MO Operators E el a lt Je e gt gt oj l Item Values Wife Spouse 2 Son Daughter 3 Son in law Daughter in law 4 Grandson Granddaughter 5 Father Mother 6 Other Relatives 7 Housemaid boy 8 Other non relatives 9 AGE_YR gt 15 and RELN 1 Cancel Help Clear 6 To delete the universe simply erase the contents of the universe condition 7 Press OK when the universe condition is complete 13 Qh FRY CBMS 8 To apply a universe to all the tables click the Apply All button to the right of the Universe box in the Tally Attributes dialog box Please note that if there is some type of error either in the typed or generated condition the system will display an Invalid Universe Syntax message and the problem must be corrected before the universe can be accepted Tally Attributes Table Tally Table Subtables Entire Table a ti ssst lt sisi i
8. type of file other than tow Save in Crosstab v hpg01200511 Zj hpq10200409 My Recent hpq1 1200411 sisati FE Core_HPQ xtb tbw Desktop My Documents 3 My Computer My Network File name sample Places Save as type CSPro Tables tbw x Cancel CSPro Tables tbw HTML Files htm Rich Text Format ASCII tab delimited g Enter the name of the file to be created or browse to select the name of the file to be replaced Note ONLY ONE table at a time can be in Rich Text rtf or HTML htm format ASCII tab delimited Format supports saving multiple tables in a single file The crosstabs created can be saved in several formats e Rich Text Format rtf Can save tables in rich text format so they can be used later by word processors such as Word or WordPerfect The tables with rtf extension when opened in word processor will appear in the word processor s table format e HTML files htm Can save tables as HTML files so they can be later incorporated into Internet applications in table format e ASCII tab delimited other Can save tables in other formats so they can be used later by a Spreadsheet such as Excel We can open the file in soreadsheet and the table will appear as a matrix of cells with columns lined up Copy tables to spreadsheets or word processing documents In crosstabs the entire table can be copied to the clipboard To copy or paste a table 1 f
9. E_HPQ_C 04 Yes 50 cm Asset Record E Death Record CORE_HP _ 05 No 50 cm Crime Record o Programs Record CORE_HPQ_F 06 Yes 50 pcm i poeenteas E Calamity record CORE_HPQ_C16 No 50 a Jawan E OFW Record CORE_HPQ_C07 No 50 om OFW Record E Couples Record CORE_HPQ_C 08 No 50 cm Couples Record O Single parents record CORE_HPQ _LO9 No 50 cam Single parents record E Board passers record CORE_HPQ_E10 No 50 ee E Exams record CORE_HPQ_E 18 No 50 umm Handicapped record O Handicapped record CORE_HPQ_H 11 No 50 cam Senior citizens record O Senior citizens record CORE_HPQ_ 12 No 50 cm Expected family members record O Expected family members record CORE_HPQ E13 No 50 E eae E Crop Record CORE_HPQ_C 15 No 50 m Livestock Record Agri equipment record CORE_HP _ 21 No 50 comm Fish cage record E Livestock Record CORE_HPQ_L17 No 50 cam Aquatic animals record E Fish cage record CORE_HPQ F23 No 50 oe a E Aquatic animals record CORE HPQ 424 No 50 SCID O Fishing equipment record CORE_HPQ 414 No 50 cmm Member Record E Trees record CORE_HPQ_T19 No 50 m Senior citizens record Core_HPO Working Storage Dictionary The data dictionary screen is divided into 2 windows The screen on the left displays the dictionary tree The screen on the right displays detailed information for the highlighted object in the left hand screen For example if in the left hand screen the focus is on the first line Core HFG the right hand screen w
10. Fa Ws a De ln Bele Acari a CRDI 3E IDRC AKI Manual for the Crosstabulation of CBMS Data using CSPro Crosstabs Prepared by the CBMS Network Coordinating Team of the Angelo King Institute for Economic and Business Studies This work was carried out by the PEP CBMS Network Coordinating Team with the financial support of the Government of Canada provided through the International Development Research Centre IDRC and the Canadian International Development Agency CIDA Manual for the Crosstabulation of CBMS Data using CSPro Crosstabs I Introduction A About CBMS CSPro The Census and Survey Processing System CSPro is a software package for entering editing tabulating and disseminating data from censuses and surveys It is designed to fulfill the census and survey data processing needs of data producing organizations worldwide This state of the art software combines the best technical features of earlier software with a user friendly interface to enhance ability to collect analyze and disseminate data CSPro is developed by MEASURE partners the U S Bureau of the Census ORC Macro s MEASURE DHS project and SerPro S A CSPro runs under Windows 98se Me NT 4 0 2000 XP Vista or 7 It is a public domain product so it can be used and distributed at no cost B Installation The CBMS Network Coordinating Team had customized the Crosstabulation application of the CSPro for the use of the local government units The HPQ and BPQ C
11. Group AGE_Y YR_V52 cag Household Record 0 5 0 5 oo Member Record 6 12 5 12 Line number Member surname 13 16 13 16 Member first name 17 and above Lt 150 Relation to the HH referenc Other relationship Sex s m 292 yeas Ane in months 4 After Completing the value properties requested press the Esc key A single value set can contain one or more values The value will always be added to the end of the value set listings Use also the Esc key when the value is added to a wrong place Note that you will have two value sets for age in years age in years and age group 15 Qh eo CBMS Core HPO O Age in years AGE_YR_V51 ore 4 Core HPQ questionnaire z E 0 150 Id Items O Age group AGE_YR_VS2 m Household Record oO 0 5 0 5 aea o 612 2 m Member surname o 13 16 13 16 m Member first name O 17 and above 17 150 m Relation to the HH reference person Other relationship MH Sex 3m m Age in years m Age group m Age in months Birth Date 5 Drag age group and sex in the table Here is the resulting Crosstab CSPro 3 3 Core_HPQ xts File Edit View Tools Window Help D Shw OWS BS Bek Ham a ka able 2 Age group by Sex Core _HPO Table 1 Civil Status by Sex Age group Table 2 Age group by Sex Sex Female m Row Items Total 1 741 570 563 Column Items 0 5 276 139 137 6 12 311 155 156 13 16 145 60 65 17 and above 1 009 504 505 G Relations Relations provide a
12. Unit Tallied Default CORE_HPQ_PER Value Tallied Weight Apply to All Tables Universe Edit Apply to All Tables Tab Logic Edit PostCalc Logic Edit Special values Use custom special values m cr Area Lowest Break Level cout eo 2 Click edit in the corresponding universe field Another dialog box to edit the universe will appear 12 Edit Universe Dictionary Tree Wn CORE_HPQ_QUEST cm CORE_HPQ_HH CORE_HPQ_MEM cm CORE_HPQ_WAGE m CORE_HPQ_ASSET cm CORE_HPQ_CRIME m CORE_HPQ_DEATH cm CORE_HPQ_PROG lt Universe _IDSO Operators J ee gt gt m o a v gt Item Values cmi tb _ 3 Expand the Dictionary tree on the left hand side of the window until the desired variable to be restricted is visible 4 Double click the variable Automatically the value for the selected item will be shown in the item value Use operators to define the universe Example let us use restrict the table to show only data for ages 15 and above AGE_YR gt 15 Note Refer to Annex 1 of the Users Manual for CBMS Statistics Simulator StatSimSGE version 4 0 for the list and meanings of the variables Edit Universe Dictionary Tree g Universe Clear cam CORE_HPQ_MEM m MEMNO m MSNAME m MFNAME m RELN MH RELN_O m SEX m AGE_YR m AGE_MO Operators lt elal gt E l oj al
13. al The last tab called Tables displays a list of tables created Relative Positions Core HPO Tau Core HPO questionnaire Id Items Core_HPQ Table 1 Relation to the HH head Table 2 Educational attainment code m Household Record m Member Record cms Wages Record Line number referenced to line number ir Wage of a HH member cash m Wage of a HH member kind cm Asset Record Crime Record m Death Record cam Programs Record cam Calamity record om OF W Record m Couples Record cam Single parents record m Board passers record om Exams record m Handicapped record m Senior citizens record m Expected family members record cam Crop Record m Agr equipment record comm Livestock Record m Fish cage record cam Aquatic animals record m Fishing equipment record m Trees record Lo Core_HP Working Storage Dictionary e i variable item If the item has more than one value set then the field will show the symbol indicating that the item can be expanded Value sets are always designated with the symbol called value set icon VI Outputs of Cross tabulation A Basic Crosstab To create a table do the following 1 Click the shortcut icon Ba to add a table 2 Select the Dictionary Dicts tab to make the dictionary file structure visible 3 Expand the tree until the item s to be used for row or column variable s appears o
14. are 11 Mean average value of observations Median middle value half of the observations are above this value and half below Mode for categorical variables this is the most frequently observed value For grouped variables this is the lower limit of the modal class or the range in the value set in which the most observations lie Std Deviation Standard Deviation a measure of how clustered the observations are around the mean or the square root of the variance Variance another measure of dispersion N tiles values that divide the values into N groups each of which contain 1 N of the total observations N 2 is equivalent to median Minimum smallest value found in all observations Maximum largest value found in all observations Proportion show counts for certain values in the value set as a fraction or percentage of the total for the variable E Universe The universe specification acts as a filter as the tables produced use only a subset of the data file s records It limits the scope of the data being outputted Therefore values in the table may be lower than they would be with no universe specified since the universe restricts the data available for tabulation To do this follow the steps below Right click on the variable in the table Choose Tally Attributes lt table gt A dialog box will appear Tally Attributes Table Tally Table Subtables Entire Tabe l
15. ary Choose a relation name that describes the new relation For example we will use SSID as the relation name to denote Senior Citizens ID Relation Specifications poa oo o aua ee Relation Name Linked By Secondary Linked By SSCID FORE HPQ MEM 7 Occ RACORE HPQ MEM Occ if 4 The primary property is the name of the record or item to be linked to the secondary item For our example we will use Core HPQ mem 5 The Linked by is the name of an item that links the primary and secondary If the primary is a record then this is the name of an item within the primary record We will choose Memno as example Since the number on each record memno and seniorcit_line that links the two records which identifies a single person is the same on both records Relation Specifications Relation Name Primary i Secondary Linked By SScID CORE HPQ MEM CORE HPQ MEM x Occ 6 Items within the secondary are linked to item in the primary The secondary cannot be the same as the primary In the secondary field choose core HPQ_seniorcit Relation Specifications cat dete Relation Name Linked By Linked By CORE HPQ SENIOR B 17 7 As mentioned in Step e the linked by is the name of the item that links the two records If the secondary is a record then this is the name of an item within the secondary record Choose the item Seniorcit_line for our example Relation Specifications Add Insert Delete
16. ells Usually information on the top header of a table and side header will meet in the middle at a particular cell with information regarding the two headers it is collinear with e Footnote note of text placed at the bottom of a table and usually contains the data source V CSPro Crosstabulation A Opening the CSPro Crosstabulation There are two ways to open the CSPro Crosstabs 1 First Method Under the C directory find the folder with file name CBMSDatabase Look for the System folder Open the Crosstab Folder Select Click Core HPQ xtb aop Organize Open New folder Mim Local Disk C2 Core BPQ del Cure BPQatt a Recycle Bin C2P rn Fertiqnery Dnecumert Cifre Crer Tab Application Dear J avterun int a Haw 392 bytes d CEMSDatmba Core POab app Core BPQucth regt Ji CBMSDataba seine aise 55 bytes 80 bytes d be Lore BP Ob wrae ore BPO als CSP ro Dictionary Dncumert OTS Fale a 457 bytes 8296 bu Core HPQLdef Core HPQatb Oa CoPro Deiene Documeril Cre Cross lab Applicabon Dot w E Mike ae yt wh oF Core HPQth app Core_HPOG sthomgt APP fi BGF File bh a bye tr Eyles iT j Carwe HPs rk de Core HPQ aty ESPnn Dirtionary Dneunmert TS File su a 457 bytes 19 KD d i hu ab 14 Ai d 16 J i ad Cambodia J CEMS NRE d COPSLSetu installers d LGU rstalk U idas mi Date created 83017 5 PM Core HPs Date modified 1071 9011 8 38 PR pe Cofra Crs Tah Application Decument Sine W bytes
17. ila Philippines 1004 Tel No 632 5262067 632 524 8888 loc 274 Fax No 632 5262067 E mail coms benilde edu ph coms network gmail com Website www pep net org 20
18. ill display information about the dictionary file as a whole If the focus in the left hand screen is moved to the second line questionnaire or case level the right hand screen will display information about the questionnaire or case which is the basic element of the file CSPro 3 3 Core HPQ File Edit View Options Tools Window Help OH One Be herx ae I haag From To Special Relation to the HH referciice g RELN_VS1 Core HPO te Core HPO questionnaire rieng 1 Id Items Wife Spouse 2 cag Household Record Son Daughter 3 Ls ie Son in law Daughter in law 4 ine number feat Mein scares Grandson Granddaughter 5 m B r first name Father Mother 6 q Relation to the HH reference person Other Relatives 7 ar Giaaraltionship Housemaid boy 8 m Sex i EE Age in years Other non relatives 9 m Age in months Birth Date As the focus is moved down the dictionary tree the right hand screen changes to reflect the different items of interest at each successive level yA MA STY CBMS IV Introduction to Tabulation CSPro has a tabulation application which allows you to tabulate data quickly and easily producing basic frequency distributions and cross tabulations from one or more data files The tabulation application has many capabilities One of these is Cross Tabulation A What is Cross tabulation Cross tabulation is taking a minimum of two data items and tabulat
19. ing the results of one data item against the other data item There may be one independent and one dependent variable in each dimension row and column Cross tabulation gives a basic picture of how two variables inter relate and can help in determining patterns of interaction Like frequency distributions cross tabulation results may be displayed as numeric values default as percentages or as both numbers and percentages B Parts of a Table 1 What is a table A table represents relationships between data set It is a set of values that is organized using a model of vertical columns and horizontal rows A table has a specified number of columns but can have any number of rows There are five basic parts of a table eS I COLUMN otal Male Female 5484 able 20 Barangay by Sex Barangay Total 11564 6080 Antipuluan 4505 2312 2193 Aramaywan ROW 3499 1868 1631 Batang batang 1947 1056 891 San Isidro Bato bato 1613 769 Burirao CELL Note no data for Burirao Source CBMS survey 2004 FOOTNOTE a Heading is the first line in the table This is also called as the title of the table It describes the contents of the table b Column shows the column variables and describes the contents of a column of data c Row shows the row variables and describes the contents of a row of data d Cell is one grouping within a table Cells are grouped horizontally rows of cells and vertically columns of c
20. n the tree 4 Drag the desired variable to the right and drop it in the table view Where we drop it on the table will determine whether it is used as a row or column variable Imagine a diagonal line connecting the top left corner of the table window to the bottom right corner dictionary items dropped below and to the left of the line will become row variables and items dropped above and to the right of the line will become row variables 5 Repeat Step d for a total of two items value sets per row and two items per column CSPro 3 3 Core_HPQ xts Eq File Edit View Tools Window Help Dad One g 8a xX ii ge gt Table 0A Sex by Civil Status Core HPQ fa Core HPQ questionnaire Civil Status Id Items i Widow er Separated Other m Person Record Total m Line number m Member surname Member first name Female m Aelation to the HH head Other relationship m Sex Age in years Age in months Birth Month m Birth Date Birth Year Dialect Language Other dialect lanquage m P Indicator m P Group m Other IP Group Blood Type Civil Status Male 6 To delete a row column variable left click on one of its value names then drag and drop it back on the dictionary tree 7 Click the icon to run the data 8 Adialog box such as below will appear Click Yes Application C CBMSDatabase System Crosstab Core_HPQ xtb has changed E Do you want to save the changes No
21. ngle 54 0 Married 33 Widower 6 1 Divorced Separated 0 7 0 6 0 9 Common Law Live in 1 4 1 4 1 5 Unknown 0 1 0 1 C Tabulate Values and or Weights Cross tabulation also allows the use of a data item or a constant value as a weighting factor This is particularly useful in the case of a survey where the weight assigned to each case or observation in the sample must be taken into account in order to produce numbers representative of the whole If no weight value is specified weight is assumed to be 1 Like weights values are numeric data items or constants with or without decimal positions When a value is specified for tabulation the effect is that of cumulative addition of the specified value into the cell at the intersection of the row and column coordinates If value item is blank a value of 1 will be added into the appropriate cell during tabulation If both value and weight are specified for a given table the specified value is first multiplied by the specified weight and the product of this multiplication is then added to the cell in question Select the universe of tabulation D Summary Statistics Cross tabulation can also include summary statistics in the tables Most of these give information about the distribution of values for the data item To add a summary statistics right click on the variable in the table Choose Tally Attributes lt variable gt and select the desired measure The choices for statistical measures
22. reating any table click this RUN icon to process the data needed for the table Values will then be shown in the table Bm To add create a new table a To Delete a table gt To view the contents of Data Dictionary which defines the data or variable ha IR CBMS The Crosstabs window is divided into two parts The left hand display contains three tabs at the bottom Files Dicts and Tables CSPro 3 3 Core_HPQ xts File Edit Yiew Tools Window Help Oa OMe amp Ba xX Core HPO uM Core HPO questionnaire Id Items m Person Record cag Household Record Core_HP Working Storage Dictionary DICTIONARY ITEMS G Files Dicts Eg Tables For Help press F1 The Files tab displays the list T of files that are being accessed or Relation to the HH head Head Wife Spouse Son Daughter Son in law Daughter in law Grandson Granddaughter Father Mother Other Relatives Housemaid boy Other non relatives 5 Core_HPO Core HPO Core _HPO Working Storage Dictionary used Logic Messages Dicts tab shows the variables that are available There are many records tables available The ID items define the regions municipality barangays and purok Member record contains a list of all variables about the household members such as age sex grade yr level and others When is selected for each corresponding category a list of fields will be shown Field EE represents the individu
23. rom the table itself right click anywhere over the cells of a table A pop up dialog box will appear Select Select All 19 CBMS CSPro LA Care HPR ws gii Fir Edt view Took Wii Hap si a L NeT a ea De a a G a o i 7 if terra Table 1 Civil Status by Sex Ei Tabet Gii by Sex m Tatts 2 Age group by Sex E Felemi HE Cinli atrial Data Cei Orarced Separated 5 LS 3 Forat Tabii Common Lae flere E a 1 Format ipelication Unknown BL Adel Tobis 2 Click copy and paste into word or excel files E Microsoft Excel Book1 B9 File Edit View Insert Format Tools Data Window Help MEA 3 MNA E SF EAE ER E ia ea 2a a T 52S A Reply with Changes End Revie i Arial gg 10 njB UE S ES Al lt fe Table 1 Civil Status by Sex Table 1 Civil Status by Sex Civil Status Sex Total Total Male Female Male Female Total 1 100 286 55 100 Single 53 1 l 21 24 2 1 0 THE CBMS NETWORK COORDINATING TEAM DR CELIA M REYES CBMS Network Leader ANNE BERNADETTE E MANDAP JASMINDA A QUILITIS JOEL E BANCOLITA JUAN PAULO M FAJARDO MARSMATH A BARIS JR ALELLIE B SOBREVINAS JEREMY L DE JESUS ERICA PAULA S SIOSON NOVEE LOR C LEYSO Research Staff Inquiries regarding this CBMS work may be sent to CBMS Network Coordinating Team Angelo King Institute for Economic and Business Studies 10th Floor Angelo King International Center Estrada Corner Arellano Avenue Malate Man
24. rosstab are installed simultaneous with the installation of the CBMS StatSim ll Preparing Encoded Data for Crosstabulation Completely encoded barangay level data is ready to be used for crosstabs However if all barangays in a municipality had already been completely encoded all the barangay files can also be concatenated so that crosstabulation can be done at the this level The following figure shows an example of concatenation of barangays to form a text file of a municipality for example data for the Municipality of Balagtas CSConcat Output File C CBMSDatabase 03 1 44024031 402000 hpq Browse Files to Concatenate order of concatenation Path Date 031402002 hpq C CBMSDatabase 0341 44024002 06 22 05 15 50 00 031402003 hpq C CBMSDatabase 0341 44024003 06 29 05 12 21 00 031402004 hpg C CBMSDatabase 03 1 44024004 06 29 05 12 23 00 031402005 hpqg C CBMSDatabase 0341 44024005 03 06 06 09 26 02 031402007 hpq C CBMSDatabase 0341 44024007 06 29 05 12 41 00 031402008 hpq C CBMSDatabase 0341 44024008 06 29 05 12 45 00 031402009 hpq C CBMSDatabase 0341 44024009 03 06 06 09 17 56 031402010 hpg C CBMSDatabase 0341 44024010 06 22 05 10 37 00 031402011 hpg C CBMSDatabase 0341 44024011 06 29 05 12 47 00 Remove Clear Cancel Help Note in the figure above shows that the output file path is This indicates that a text file 031402000 hpq will be created containing the data from the Files to concatenate
25. s Table single 1 012 546 ABE Married 627 305 322 Format Spanner Widow er 63 10 53 Format Table Divorced Separated 13 5 E Format Application Common Law Live in 25 12 13 niena 1 1 o Format Print Table B Add Table g Insert Table X Delete Table 2 A window shown below will appear Tally Attributes Sex Available Selected Total Counts 3 Select Percents in the list of available calculations on the left hand side of the dialog and click the Add button Then highlight Percents Column Interleaved and click the button Options Selected Total Total Percent Same as Percents Counts eas Percents Column Interleaved lt Remove a Percent Options Type fColumn v Display of both counts and percents Up pe Separate Interleaved Options 4 There are three types of percentages users can opt i Total Percents are based on total cell for the table cell associated cell value 100 total of all the cells in the table ii Row Percents are based on total for the row cell associated cell value 100 total of all the cells in the row ili Column Percents are based on total for the column cell associated cell value 100 total of all the cells in column 5 Interleaved Separate By default percents and counts are interleaved that is for each value in the value set the frequency for that value is lis
26. ted in the column row directly preceding or following the percent for that value Percents may also be separate in which case all the frequencies are grouped together and all the percents are grouped together Sex Interleaved Percents Bx Separate Percents 10 QM ST CBMS For percents to be interleaved the percents must directly follow or directly precede the counts in the list of selected calculations in the tally attributes dialog The position of the percents can be changed relative to the other selected calculations including the counts by selecting the percents in the list on the right hand side of the dialog and clicking the Up or Down buttons 6 To show percents only percents without counts add the percents as described above and set the options to Separate Then select the counts in the list of selected calculations on the right hand side of the dialog and click the Remove button to delete the counts Do the same to remove the Total Click OK Tally Attributes Sex Available Selected E Total Percent Same as Percents Percents Column Separate poe sm os Cancel Reset Help 7 Repeat steps VI A 7 and 8 to generate the table below CSPro 3 3 Core _HPQ xts File Edit View Tools Window Help Oe ee OBS BS aa xk Fe B Table 1 Civil Status by Sex Core_HPO e eA oe 7 rAr Table 1 Civil Status by Sex Civil Status Female Total 100 0 Si
27. way of linking one multiple record or item to one or more multiple records or items Once the items on different records are linked through a relation tallies are done just as if all the items belonged to one record Relations work much like database joins Relations have one primary multiple record or item Each instance of the primary element in a case is processed one at a time A relation has one or more secondary records or items The corresponding secondary elements are linked to the primary element during processing For example we want to cross tabulate Senior citizens with ID by Sex We should first add a relation to link the Senior Citizens record with the Member Record To do this here are the steps 1 Inthe menu toolbar click Edit and select Relations File view Options Tools Window Help D hi Relations ih Eind Ctrl F cam Board passers record cam Exams record 16 JE IR CBMS 2 A dialog box will then appear Click the Add button to add a relation at the end of the list or press the Insert button to insert a relation at the current highlighted line Click Delete button to delete the highlighted line Relation Specifications Relation Name Primary Linked By Secondary Linked By CORE HPQ MEM Occ CORE HPQ MEM Occ 7 OK Cancel Help 3 Notice that there are five Relation properties to be filled The first relation property is the relation name Relation name is arbitr
Download Pdf Manuals
Related Search