Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The code below was tested only on your small data snippet. So, no guarantees for all the data with their peculiarities. The code makes the assumption that AGE is integer.</p> <pre><code>*Let's add small fractional noise to those children AGE who HASHEALTH=1. *In order to insert the info about health right into the age number. if hashealth age= age+rv.unif(-.1,+.1). *Turn to fathers. Combine POPNUM and PID numbers in one column. compute parent= popnum. /*Copy POPNUM as a new var PARENT. if parent=0 parent= pid. /*and if the case is not a child, fill there PID. *Now a father and his children have the same code in PARENT *and so we can propagate the minimal age in that group (which is the age of the *youngest child, provided the man has children) to all cases of the group, *including the father. aggregate /outfile= * mode= addvari /break= hhid parent /*breaking is done also by household, of course /youngage1= min(age). /*The variable showing that minimal age. *Turn to mothers and do the same thing. compute parent= momnum. if parent=0 parent= pid. aggregate /outfile= * mode= addvari /break= hhid parent /youngage2= min(age). /*The variable showing that minimal age. *Take the minimal value from the two passes. compute youngage= min(youngage1,youngage2). *Compute binary KIDHASHEALTH variable. *Remember that YOUNGAGE is not integer if that child has HASHEALTH=1. compute kidhashealth= 0. if popnum=0 and momnum=0 /*if we deal with a parent and age&lt;&gt;youngage /*and the youngage age listed is not their own and rnd(youngage)&lt;&gt;youngage kidhashealth= 1. /*and the age isn't integer, assign 1. compute age= rnd(age). /*Restore integer age exec. delete vari parent youngage1 youngage2 youngage. </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POProgrammatically copying data between cases using SPSS
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USpagibson
    1. USttnphns
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POProgrammatically copying data between cases using SPSS
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis is brilliant, thank you so much. The only issue I found was that people with no children ended up with kidhashealth = 1, but this should be a quick fix; I'll post with results here.
      singulars
      1. PO
      1. USpagibson
    2. COIf you find difficulty to fix that please ask.
      singulars
      1. PO
      1. USttnphns
    3. COIt was a simple matter of adding 'and age<>youngage' to the last conditional to prevent people with no children from being considered their own children and throwing things off if their own hashealth=1. I'll edit the answer to reflect this.
      singulars
      1. PO
      1. USpagibson
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload