<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;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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">I’m guessing that the features in DDI3.2 for handling this are still too new for existing tools to handle complex SAS numeric variables completely, but the
structure is there now in DDI3.2 to do so. The following SAS code illustrates the issue. A variable (named “value”) is numeric and has labeled values, ranges and missing values of several types. The low and high ranges might be recoded to missing values, but
they might also be used as valid data. The format could be used for the transformation and it also documents the ranges. There is also a labeled valid value.
<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">It looks like the SAS format would need to be split up in DDI3.2 into a ManagedNumericRepresentation for the valid values and a ManagedMissingValuesRepresentation
for the missing values, since it is not possible to have non-numeric values bounding the NumberRange.<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"><l:VariableRepresentation><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> <r:NumericRepresentationReference><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> <r:URN>URN:DDI:exampleagency.subagency:7ef2bb24-c3b0-4b50-9195-270e18dbdec0:1.0</r:URN><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> <r:TypeOfObject>ManagedNumericRepresentation</r:TypeOfObject><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </r:NumericRepresentationReference><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> <l:MissingValuesReference><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> <r:URN>URN:DDI:exampleagency.subagency:MMVR1:1.0</r:URN><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> <r:TypeOfObject>ManagedMissingValuesRepresentation</r:TypeOfObject>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </l:MissingValuesReference><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </l:VariableRepresentation><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">The representation of the valid values of the variable (without the missing values) can be described in DDI3.2 with a ManagedNumericRepresentation. Note that
this includes the possibility of labels for the ranges. <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="color:black"> </span><span style="color:#000096"><r:ManagedNumericRepresentation></span><span style="color:black"><br>
</span><span style="color:#000096"><r:URN></span><span style="color:black">URN:DDI:exampleagency.subagency:7ef2bb24-c3b0-4b50-9195-270e18dbdec0:1.0</span><span style="color:#000096"></r:URN></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Content></span><span style="color:black">UFMT.N</span><span style="color:#000096"></r:Content></span><span style="color:black"><br>
</span><span style="color:#000096"></r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Description></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Content></span><span style="color:black">Labeled numeric ranges generated from the SAS format UFMT.N</span><span style="color:#000096"></r:Content></span><span style="color:black"><br>
</span><span style="color:#000096"></r:Description></span><span style="color:black">
<br>
</span><span style="color:#000096"><r:NumberRange></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Content></span><span style="color:black">32 calibration value</span><span style="color:#000096"></r:Content></span><span style="color:black"><br>
</span><span style="color:#000096"><r:TypeOfLabel></span><span style="color:black">text</span><span style="color:#000096"></r:TypeOfLabel></span><span style="color:black"><br>
</span><span style="color:#000096"></r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Low</span><span style="color:#F5844C"> isInclusive</span><span style="color:#FF8040">=</span><span style="color:#993300">"true"</span><span style="color:#000096">></span><span style="color:black">0</span><span style="color:#000096"></r:Low></span><span style="color:black"><br>
</span><span style="color:#000096"><r:High</span><span style="color:#F5844C"> isInclusive</span><span style="color:#FF8040">=</span><span style="color:#993300">"true"</span><span style="color:#000096">></span><span style="color:black">0</span><span style="color:#000096"></r:High></span><span style="color:black"><br>
</span><span style="color:#000096"></r:NumberRange></span><span style="color:black"><br>
</span><span style="color:#000096"><r:NumberRange></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Content></span><span style="color:black">out of bounds high</span><span style="color:#000096"></r:Content></span><span style="color:black"><br>
</span><span style="color:#000096"><r:TypeOfLabel></span><span style="color:black">text</span><span style="color:#000096"></r:TypeOfLabel></span><span style="color:black"><br>
</span><span style="color:#000096"></r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Low</span><span style="color:#F5844C"> isInclusive</span><span style="color:#FF8040">=</span><span style="color:#993300">"false"</span><span style="color:#000096">></span><span style="color:black">110.0000000000</span><span style="color:#000096"></r:Low></span><span style="color:black"><br>
</span><span style="color:#000096"></r:NumberRange></span><span style="color:black"><br>
</span><span style="color:#000096"><r:NumberRange></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:Content></span><span style="color:black">out of bounds low</span><span style="color:#000096"></r:Content></span><span style="color:black"><br>
</span><span style="color:#000096"><r:TypeOfLabel></span><span style="color:black">text</span><span style="color:#000096"></r:TypeOfLabel></span><span style="color:black"><br>
</span><span style="color:#000096"></r:Label></span><span style="color:black"><br>
</span><span style="color:#000096"><r:High</span><span style="color:#F5844C"> isInclusive</span><span style="color:#FF8040">=</span><span style="color:#993300">"true"</span><span style="color:#000096">></span><span style="color:black">-30.0000000000</span><span style="color:#000096"></r:High></span><span style="color:black"><br>
</span><span style="color:#000096"></r:NumberRange></span><span style="color:black"><br>
</span><span style="color:#000096"></r:ManagedNumericRepresentation></span><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">The missing values would be described by a ManagedMissingValuesRepresentation pointing to a codelist. A choice could be made here as to whether to use codes
like “.a” or “A”. The latter is how the missing values are exported from SAS so that is probably the better option. The Codes could, of course, point to Categories for the labels.<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="color:#000096"><r:ManagedMissingValuesRepresentation></span><span style="color:black"><br>
</span><span style="color:#000096"><r:URN></span><span style="color:black">URN:DDI:exampleagency.subagency:MMVR1:1.0</span><span style="color:#000096"></r:URN></span><span style="color:black"><br>
</span><span style="color:#000096"><r:MissingCodeRepresentation></span><span style="color:black"><br>
</span><span style="color:#000096"><r:CodeListReference></span><span style="color:black"><br>
</span><span style="color:#000096"><r:URN></span><span style="color:black">URN:DDI:exampleagency.subagency:CDLST1:1.0</span><span style="color:#000096"></r:URN></span><span style="color:black"><br>
</span><span style="color:#000096"><r:TypeOfObject></span><span style="color:black">CodeList</span><span style="color:#000096"></r:TypeOfObject></span><span style="color:black"><br>
</span><span style="color:#000096"></r:CodeListReference></span><span style="color:black"><br>
</span><span style="color:#000096"></r:MissingCodeRepresentation></span><span style="color:black"><br>
</span><span style="color:#000096"></r:ManagedMissingValuesRepresentation></span><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"><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"><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" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:green;background:white">/* Test dataset for SAS missing Data */</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">libname</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> L
</span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">'C:\Ddrive\projects\various\DDI\SASMissingData'</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:navy;background:white">proc</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">
</span><b><span style="font-size:11.0pt;font-family:"Courier New";color:navy;background:white">format</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">
</span><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">cntlout</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">=L.formats;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">value</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> ufmt<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">low - -</span><b><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">30</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">
= </span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">'out of bounds low'</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">0</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> =
</span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">'32 calibration value'</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">110</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> <- high =
</span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">'out of bounds high'</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">.</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> =
</span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">'system missing'</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">.s</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> =
</span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">"scheduled"</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">.i</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> =
</span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">'instrument failure'</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">._</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> =
</span><span style="font-size:11.0pt;font-family:"Courier New";color:purple;background:white">'underscored missing'</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:11.0pt;font-family:"Courier New";color:navy;background:white">data</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> L.testData;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">input</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> value sequenceNumber;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">datalines</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">-40 0<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">1 1<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">32 2<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">78 3<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">. 4<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">.s 5<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">.d 6<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">.i 7<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">._ 8<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:#FFFFC0">201 9<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">data</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> L.testDataFormatted;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">set</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> L.testData;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:blue;background:white">format</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"> value
</span><span style="font-size:11.0pt;font-family:"Courier New";color:teal;background:white">ufmt.</span><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">;<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Courier New";color:navy;background:white">run</span></b><span style="font-size:11.0pt;font-family:"Courier New";color:black;background:white">;</span><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"><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>
<div>
<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>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<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""> Hoyle, Larry
<br>
<b>Sent:</b> Friday, June 20, 2014 1:11 PM<br>
<b>To:</b> 'Data Documentation Initiative Users Group'<br>
<b>Subject:</b> RE: [DDI-users] DDI software that recognizes extended Stata/SAS missing values?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">This is a somewhat tricky issue in that “.a” et al are numeric but “out of band” in that they are not valid numbers (they are missing codes) but are part of
a numeric representation. You asked about tools that handle these.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’ve been working on a SAS Enterprise Guide tool to generate DDI 3.2 let me check as to whether It’s handling these missing codes in the fashion that Achim
and I discussed.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">I’m also not sure about some of the other tools, but will take a look at those I have access to as well.<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"">
<a href="mailto:ddi-users-bounces@icpsr.umich.edu">ddi-users-bounces@icpsr.umich.edu</a> [<a href="mailto:ddi-users-bounces@icpsr.umich.edu">mailto:ddi-users-bounces@icpsr.umich.edu</a>]
<b>On Behalf Of </b>Wendy Thomas<br>
<b>Sent:</b> Friday, June 20, 2014 11:05 AM<br>
<b>To:</b> Data Documentation Initiative Users Group<br>
<b>Subject:</b> Re: [DDI-users] DDI software that recognizes extended Stata/SAS missing values?<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hi Bob,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">In DDI 3.2 there is a specific differentiation between valid and invalid (missing values) so that they are declared separately. In PhysicalDataProduct the PhysicalStructure/DefaultMissingData can be used for this as this is a description
of a specific file type (like SAS, etc.). Larry Hoyle or Achim Wackerow can probably provide more details as they were looking at the new structure for Missing Values in this context while it was being developed.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Wendy<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Fri, Jun 20, 2014 at 10:26 AM, Bob McConnaughey <<a href="mailto:bobmcconn@gmail.com" target="_blank">bobmcconn@gmail.com</a>> wrote:<o:p></o:p></p>
<div>
<p class="MsoNormal">Dear Folks:<o:p></o:p></p>
<div>
<p class="MsoNormal"> Do any of the DDI documentation/codebook generating packages handle extended Stata/SAS missing values? .a-.z ; "."? Our analysis datasets (as opposed to the original questionnaires) invariably use multiple sets of special missing codes,
and converting every thing into faux numeric missings (-1---9) for instance kind of defeats the purpose.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">any way forwards will be most appreciated.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">thanks<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">bob<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p>Bob McConnaughey, PhD.<br>
Westat/NIEHS epidemiology branch contractor<br>
<a href="tel:919-941-8300" target="_blank">919-941-8300</a> (w)<br>
<a href="tel:919-542-5653" target="_blank">919-542-5653</a> (h)<br>
<br>
<span style="font-family:"Comic Sans MS"">"She is at the brink of never being hurt again</span><br>
<span style="font-family:"Comic Sans MS"">but pauses to say, All of us. Every blade of grass."</span><br>
<span style="font-family:"Comic Sans MS"">from <em><span style="font-family:"Comic Sans MS"">Kuan Yin</span></em>, Laura Fargas</span><o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
DDI-users mailing list<br>
<a href="mailto:DDI-users@icpsr.umich.edu">DDI-users@icpsr.umich.edu</a><br>
<a href="http://lists.icpsr.umich.edu/mailman/listinfo/ddi-users" target="_blank">http://lists.icpsr.umich.edu/mailman/listinfo/ddi-users</a><o:p></o:p></p>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <o:p></o:p></p>
<div>
<p class="MsoNormal">Wendy L. Thomas Phone: +1 612.624.4389<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Data Access Core Director Fax: +1 612.626.8375<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Minnesota Population Center Email: <a href="mailto:wlt@umn.edu" target="_blank">
wlt@umn.edu</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">University of Minnesota<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">50 Willey Hall<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">225 19th Avenue South<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Minneapolis, MN 55455<o:p></o:p></p>
</div>
</div>
</div>
</body>
</html>