<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Bob-<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I think that while this was a problem in DDI3.1, DDI3.2 does finally have the objects necessary to document missing values from SAS for continuous variables.
We just need the tools to catch up to using the added features (In the VariableRepresentation MissingValuesReference to a ManagedMissingValuesRepresentation)
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">The ManagedMissingValuesRepresentation can point to a Codelist for your<o:p></o:p></span></p>
<p class="MsoNormal">.r = 'respondent refused'<o:p></o:p></p>
<p class="MsoNormal">.d = "don't know"<o:p></o:p></p>
<p class="MsoNormal">.i = "imputed deletion"<o:p></o:p></p>
<p class="MsoNormal">. = "missing" /* just missing from the qx or biological sample */<o:p></o:p></p>
<p class="MsoNormal">.l = "lost to followup"<o:p></o:p></p>
<p class="MsoNormal">.m = "missing portion of derived var" <br>
<br>
<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">--- Larry Hoyle<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> ddi-users-bounces@icpsr.umich.edu [mailto:ddi-users-bounces@icpsr.umich.edu]
<b>On Behalf Of </b>Bob McConnaughey<br>
<b>Sent:</b> Thursday, June 26, 2014 2:12 PM<br>
<b>To:</b> ddi-users@icpsr.umich.edu<br>
<b>Subject:</b> Re: [DDI-users] DDI-users Digest, Vol 105, Issue 14<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Just fyi:<o:p></o:p></p>
<div>
<p class="MsoNormal">and i hope i'm not trying everybody's patience here.<o:p></o:p></p>
</div>
<p class="MsoNormal">Our datasets are generally a mix of demographic/behavioral variables + host of "biologic" variables whether hormonal profiles of urine samples (daily urines for up to 6 months in the study I've worked on for decades) or now, for better
or worse, oodles (the scientific term..) of genetic based vars - there could be, literally, 1000s of snps for each subject. yuck. AND then (far too many imo ;-) variables that attempt to capture all the various and sundry "exposure" variables.<o:p></o:p></p>
</div>
<p class="MsoNormal"> we've working towards a more or less standard set of SAS missing values that attempt to deal with basic "missing situations" - but with the long history of some of these projects, even now we're not completely there, yet.
<o:p></o:p></p>
</div>
<p class="MsoNormal">.r = 'respondent refused'<o:p></o:p></p>
</div>
<p class="MsoNormal">.d = "don't know"<o:p></o:p></p>
</div>
<p class="MsoNormal">.i = "imputed deletion"<o:p></o:p></p>
</div>
<p class="MsoNormal">. = "missing" /* just missing from the qx or biological sample */<o:p></o:p></p>
</div>
<p class="MsoNormal">.l = "lost to followup"<o:p></o:p></p>
</div>
<p class="MsoNormal">.m = "missing portion of derived var" <br>
/* say a derived rate of change var requires 5 days of progesterone */<o:p></o:p></p>
<div>
<p class="MsoNormal"> /* hormone and only has 3 days in the sequence, .m could reflect that */<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">(the above is not completely accurate - i'm at home w/ the world cup.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Character variables are different kettle of fish.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">a simple study might be one i've worked on forever: Early Pregnancy Study<br>
<a href="http://www.niehs.nih.gov/research/atniehs/labs/epi/studies/eps/index.cfm">http://www.niehs.nih.gov/research/atniehs/labs/epi/studies/eps/index.cfm</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">a somewhat more complex study: Norway Facial Clefts<br>
<a href="http://www.niehs.nih.gov/research/atniehs/labs/epi/studies/ncl/index.cfm">http://www.niehs.nih.gov/research/atniehs/labs/epi/studies/ncl/index.cfm</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">a horribly complex study on which i've not had to work much: Sisters Breast Cancer Study<br>
<a href="http://www.niehs.nih.gov/research/atniehs/labs/epi/studies/sister/index.cfm">http://www.niehs.nih.gov/research/atniehs/labs/epi/studies/sister/index.cfm</a><br>
<br>
As I've mentioned before, my ideal would be to convince everyone (besides the PIs with whom i've worked most closely ) that having the excellent base of documentation provided by various DDI based solutions (Nesstar, Collectica (which i haven't worked with)
is not just a good idea, but necessary. For many years we used a Cobo l/ Vax based codebook generation which was MUCH better than nothing, although v. long in the tooth. But that was discarded ~ 14 yrs ago and I regard the replacement (annotated questionnaires,
SAS proc contents and various modes of summarizing each variable) as less than satisfactory. But the missing values bit is the most frequently used argument against DDI solutions.
<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Though I'm tempted to take frequencies of just the various missings for each variable and paste them into one of the documentation fields available for each variable.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial","sans-serif";color:#222222;background:white">Bob McConnaughey</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial","sans-serif";color:#222222;background:white">Westat/NIEHS Epidemiology Support.</span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;font-family:"Arial","sans-serif";color:#222222"><br>
<span style="background:white">"At times like this, an adult needs a drink."</span><br>
<span style="background:white">Dance, Dance, Dance. H. Murakami</span></span> <o:p>
</o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>