The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Fertility » Indonesia vcal calendar data
Re: Indonesia vcal calendar data [message #18181 is a reply to message #3648] Mon, 07 October 2019 18:48
 zelalemth Messages: 4Registered: August 2018 Location: United States Member
I was trying to convert the STATA code to SAS but I was not getting same results as in the tables. I am not sure if I converted the code correctly.

data data1;
set c.RWIR70FL;

* Calculate still births in the last 5 years;
stillbirths = 0;
births = 0;
nlbirths = 0;

* Set length of calendar to use;
callen = v018 + 59;
* If calendar is aligned right (as in original dataset), use the following;
beg = v018;
end = callen;

/* If calendar is aligned left (as it appears to be), use the following;
beg = 1;
end = 60;*/

* Loop through calendar summing births, non-live pregnancies and stillbirths
forvalues i = 1/80 {;
do i = 1 to 80;
* Restrict to 60 months preceding survey;
if i >= beg & i <= end & substr(vcal_1,i,1) = "B" then births = births+1;

if i >= beg & i <= end & substr(vcal_1,i,1) = "T" then nlbirths = nlbirths+1;

if i >= beg & i <= end & substr(vcal_1,i,7) = "TPPPPPP" then stillbirths = stillbirths+1;

end;

* total pregnancies in last 5 years;
totpreg5 = births+nlbirths;
* total pregnancies of 7+ months in last 5 years (all live births, plus the stillbirths);
totpreg7m = births+stillbirths;

* Create weight variable;
sweight = v005/1000000;

run;

* Set up parameters for complex samples and produce number of stillbirths;
proc surveyfreq data = data1;
cluster v021;
strata v023;
weight sweight;
tables stillbirths totpreg7m totpreg5;

run;

[Updated on: Mon, 07 October 2019 18:50]

Report message to a moderator

 Indonesia vcal calendar data By: adev on Wed, 07 January 2015 14:08 Re: Indonesia vcal calendar data By: Trevor-DHS on Thu, 08 January 2015 10:45 Re: Indonesia vcal calendar data By: adev on Mon, 12 January 2015 05:08 Re: Indonesia vcal calendar data By: adev on Thu, 22 January 2015 09:07 Re: Indonesia vcal calendar data By: Trevor-DHS on Thu, 22 January 2015 11:20 Re: Indonesia vcal calendar data By: adev on Sat, 24 January 2015 11:39 Re: Indonesia vcal calendar data By: Liz-DHS on Wed, 28 January 2015 11:42 Re: Indonesia vcal calendar data By: adev on Mon, 02 February 2015 16:12 Re: Indonesia vcal calendar data By: tege2004@gmail.com on Mon, 12 December 2016 01:15 Re: Indonesia vcal calendar data By: Liz-DHS on Thu, 02 February 2017 14:07 Re: Indonesia vcal calendar data By: zelalemth on Mon, 07 October 2019 18:48 Re: Indonesia vcal calendar data By: Trevor-DHS on Tue, 08 October 2019 09:48 Re: Indonesia vcal calendar data By: Mark on Tue, 07 January 2020 01:36 Re: Indonesia vcal calendar data By: Liz-DHS on Tue, 07 January 2020 09:17 Re: Indonesia vcal calendar data By: Mark on Thu, 09 January 2020 05:32 Re: Indonesia vcal calendar data By: Trevor-DHS on Mon, 02 February 2015 16:58 Re: Indonesia vcal calendar data By: adev on Wed, 04 February 2015 07:48 Re: Indonesia vcal calendar data By: Trevor-DHS on Wed, 04 February 2015 08:14 Re: Indonesia vcal calendar data By: adev on Fri, 20 February 2015 05:25 Re: Indonesia vcal calendar data By: Trevor-DHS on Fri, 20 February 2015 10:12 Re: Indonesia vcal calendar data By: plnep on Tue, 27 October 2015 02:20 Re: Indonesia vcal calendar data By: Trevor-DHS on Tue, 24 November 2015 19:23
 Previous Topic: B11 is actually missing or it represent first birth? Next Topic: last birth
Goto Forum:

Current Time: Tue Mar 31 14:32:56 Eastern Daylight Time 2020