Introducing 

Prezi AI.

Your new presentation assistant.

Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.

Loading…
Transcript

Processing Other CBMS data using the SQL syntax

Customizing Tables

  • StatSim outputs value labels instead of values
  • The command executes on an existing table

Customizing Tables

  • The command can also work using string variables
  • By default, the table hpq_mem is the one active

Customizing Tables

  • The command tab msname sex shows the surname of members tabulated according to sex
  • All fields/variables under this table can be called to be tabulated
  • StatSim outputs value labels instead of values. The command can also work using string variables
  • Users must know the variable names (short names) of their data dictionary in order to proceed
  • The command use hpq_hh shifts the focus of the command on hpq_hh table
  • Click the Execute command button under the Stats/Indicators tab and a dialog box prompting the user to enter a command will pop up
  • For instance, the command tab civstat sex outputs a cross-tabulation of civil status and sex

Customizing Tables

  • Hence, the follow up command tab cropind fshort shows frequency of households who are engaged in crop farming and gardening whether they experienced hunger

Customizing Tables

  • Another command is fdt which generates a frequency distribution table (fdt).
  • Aside from the automatically generated data, users can also create their own tables using all variables found in the HPQ
  • For example, the command fdt age_yr sex generates a table of frequency distribution of age range by fives and by sex
  • Kindly refer to the Manual on Executing SQL statements to generate CBMS data using StatSim
  • An addition to this version is the “Execute Command" similar to that of Stata

Thank you!!!

Partnership for Economic Policy (PEP) Asia

Community-based Monitoring System (CBMS) Network Office

DLSU Angelo King Institute for Economic and Business Studies

10th Floor Angelo King International Center

Estrada corner Arellano Avenue, Malate, Manila, Philippines 1004

Tel. No.: (632) 5262067 or 5238888 loc. 274

Fax Number: (632) 5262067

Website: http://pep-net.org

Email: cbms.network@gmail.com

Facebook Page: http://facebook.com/CBMSPhilippines

Facebook Interactive Group: https://www.facebook.com/groups/CBMSNetwork/

Learn more about creating dynamic, engaging presentations with Prezi