<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Jeff,<br>
<br>
Try using the FMT command instead of the If-then.<br>
<br>
DOWNLOAD PERSON SECONDARY.FILE APPLICANTS @ID APPLICANTS->X.APP.SAT
FMT "4'9'R" <br>
<br>
This will give you the field if there is info in there or fill it with
9's if it is blank.<br>
<br>
<br>
<br>
Jeffery G. Summers wrote:
<blockquote cite="mid:001c01c7ff9d$85ff5500$59010a0a@compcenterjgs"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode">
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="State"><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType">
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City">
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"><!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Verdana;
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";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1428428607;
mso-list-type:hybrid;
mso-list-template-ids:664983256 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style></o:SmartTagType></o:SmartTagType></o:SmartTagType></o:SmartTagType></o:SmartTagType></o:SmartTagType>
<div class="Section1">
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">I’m trying to avoid:<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<ol style="margin-top: 0in;" start="1" type="1">
<li class="MsoNormal" style=""><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Doing additional
changes in Excel after-the-fact, and/or<o:p></o:p></span></font></li>
<li class="MsoNormal" style=""><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Creating additional
computed columns<o:p></o:p></span></font></li>
</ol>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">We’re involved in a
pilot study and must provide
data to the think-tank in charge of the study.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">The requirements for
several fields are to fill in any
blank values for fields with “9” for however many characters for
the field in question. I don’t understand why the think-tank can
ignore “9999” and not “blank” but I must comply with
the data requirements nevertheless! </span></font><font
face="Wingdings" size="2"><span
style="font-size: 10pt; font-family: Wingdings;">J</span></font><font
face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">For many of these
fields in DOWNLOAD I’m able to do:<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><b><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New"; font-weight: bold;">EVAL
“IF field THEN
field ELSE ‘999’”<o:p></o:p></span></font></b></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">I’m having trouble with
SECONDARY.FILE fields.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">For example, we have a
field for SAT Verbal in
APPLICANTS. If I do the DOWNLOAD statement in APPLICANTS then my logic
above works fine for the field(s) in question. But the majority of
fields
come from PERSON, so overall less fields will need to use this
“IF-THEN”
logic. Otherwise I’d use APPLICANTS as my “starting point”
file. Regardless of which file is my primary file I’ll need to have
some fields like this:<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><b><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New"; font-weight: bold;">EVAL
“IF
file->field THEN file->field ELSE ‘999’”<o:p></o:p></span></font></b></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Unfortunately this only
returns null values. Is
there something I should do differently in DOWNLOAD for this logic to
work or
am I stuck with options #1 & #2 at the top?<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Thanks for any
suggestions!<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Jeffery G. Summers<o:p></o:p></span></font></p>
<p class="MsoNormal"><st1:place w:st="on"><st1:PlaceName w:st="on"><font
face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Transylvania</span></font></st1:PlaceName><font
face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"> <st1:PlaceType
w:st="on">University</st1:PlaceType></span></font></st1:place><font
face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">300 N. Broadway<o:p></o:p></span></font></p>
<p class="MsoNormal"><st1:place w:st="on"><st1:City w:st="on"><font
face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Lexington</span></font></st1:City><font
face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">, <st1:State w:st="on">KY</st1:State>
<st1:PostalCode w:st="on">40508</st1:PostalCode></span></font></st1:place><font
face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><a
moz-do-not-send="true" href="mailto:jsummers@transy.edu">jsummers@transy.edu</a><o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
</div>
<div>
<hr>Successfully scanned by McAfee SIG 3200 Appliance.
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
download-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a>
<a class="moz-txt-link-freetext" href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Pam Theodore
Director of Enrollment Information Systems
Marymount University
2807 North Glebe Road
Arlington, VA 22207-4299
phone: 703.526.6815
fax: 703.522.0349 </pre>
</body>
</html>