Project

General

Profile

Support #2023

Is there a variable which indicates if a respondent is a single parent? Also how to count .00 as missing.

Added by Connor Drake 4 months ago. Updated about 2 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
Data documentation
Start date:
01/03/2024
% Done:

100%


Description

Hi there,

I am currently analysing data from wave 13, though this analysis was originally carried out on wave 10 data as this was the most recent dataset which asked the questions we were looking at. I am posting as wondering if there is a simple(r) way to determine if a respondent is a single parent than the steps I have taken (outlined below - excuse the long syntax trail and attached images!), but also to ask for advice on how to fix an issue where I am getting .00 in a frequency table for wave 13 even though the syntax remains the same.

Steps I have taken for this analysis:

1. I have created a variable which bands the number of children into 0, 1, 2 and more than 3, using the following syntax:

compute newchildbands=0.

if j_ndepchl_dv=-9 newchildbands=-9.
if j_ndepchl_dv=-8 newchildbands=0.
if j_ndepchl_dv=-2 newchildbands=-2.
if j_ndepchl_dv=-1 newchildbands=-1.
if j_ndepchl_dv=0 newchildbands=0.
if j_ndepchl_dv=1 newchildbands=1.
if j_ndepchl_dv=2 newchildbands=2.
if j_ndepchl_dv=3 newchildbands=3.
if j_ndepchl_dv=4 newchildbands=3.
if j_ndepchl_dv=5 newchildbands=3.
if j_ndepchl_dv=6 newchildbands=3.
if j_ndepchl_dv=7 newchildbands=3.
if j_ndepchl_dv=8 newchildbands=3.
if j_ndepchl_dv=11 newchildbands=3.

ADD VALUE LABELS newchildbands
-9 "Missing"
-2 "Refusal"
-1 "Don't know"
0 "No children"
1 "One child"
2 "Two children"
3 "Three or more children".

Wave 10 frequencies table for 'newchildbands':

Wave 13 frequencies table for 'newchildbands':

2. I have created a single parents variable, combining the newly-created newchildbands variable with j_marstat and m_marstat in the respective dataset for waves 10 and 13, using the following syntax.

compute singleparents=0.

if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=1 singleparents=1.
if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=4 singleparents=1.
if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=5 singleparents=1.
if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=6 singleparents=1.
if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=7 singleparents=1.
if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=8 singleparents=1.
if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=9 singleparents=1.
if newchildbands=1 or newchildbands=2 or newchildbands=3 and m_marstat=2 or m_marstat=3 singleparents=2.
if newchildbands=0 and m_marstat=1 or m_marstat=4 or m_marstat=5 or m_marstat=6 or m_marstat=7 or m_marstat=8 or m_marstat=9 singleparents=3.
if newchildbands=0 and m_marstat=2 or m_marstat=3 singleparents=4.

ADD VALUE LABELS singleparents
1 "Single parent"
2 "Parent with partner"
3 "Single but no children"
4 "Partnered and no children".

Wave 10 frequencies table for 'singleparents':

Wave 13 frequencies table for 'singleparents':

Apologies if I'm missing something fairly simple in my syntax or in a variable I could use alternatively instead, and I hope that I haven't added too much information in my attempts to be as detailed as possible! I can, of course, provide more information if needed and any advice that you can provide is more than appreciated!

Thanks,

Connor


Files

newchildbands Wave 10.png (14.6 KB) newchildbands Wave 10.png Connor Drake, 01/03/2024 12:04 PM
newchildbands Wave 13.png (14.7 KB) newchildbands Wave 13.png Connor Drake, 01/03/2024 12:04 PM
singleparents Wave 10.png (16.2 KB) singleparents Wave 10.png Connor Drake, 01/03/2024 12:04 PM
singleparents Wave 13.png (16.2 KB) singleparents Wave 13.png Connor Drake, 01/03/2024 12:04 PM
#1

Updated by Understanding Society User Support Team 4 months ago

  • Category changed from Data analysis to Data documentation
  • Status changed from New to Feedback
  • % Done changed from 0 to 50
  • Private changed from Yes to No

Hello Connor,

Are you using "indresp" file? The total number of observations you showed differs from the current release. For wave 10, there are 34,319 observations, and for wave 13, there are 27,998 observations. Have you re-tabulated the wave 10 frequencies, or are you using the previously obtained?

The variables you're working with, w_ndepchl_dv and w_marstat, have been part of the study since wave 1 and persist across all waves, including waves 11 and 12.

I would recommend using w_marstat_dv instead of w_marstat since it harmonizes de facto marital status (w_marstat), resulting in fewer response options and facilitating the analysis process.

The 00 frequencies might be associated with the negative response options (-7 proxy, -2 refusal, -1 don't know) of the variable m_marstat, along with the combinations involving -8 inapplicable in variable m_ndepchl_dv.

I hope this information is helpful.

Best wishes,
Roberto Cavazos
Understanding Society User Support Team

#2

Updated by Understanding Society User Support Team about 2 months ago

  • Status changed from Feedback to Resolved
  • % Done changed from 50 to 100

Also available in: Atom PDF