<div dir="ltr">Thanks, David -- I had thought of using a Computed Column, but we don't do much custom programming here (not even CC's), but it looks like you gave us a good head start, so we'll go down that road (for awhile, anyway) ...<br>
<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Dec 11, 2013 at 7:03 AM, Rotman, David <span dir="ltr"><<a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Using an exploded list would generally produce one line per award, which appears to not be what you want.<div>
<br></div><div>Our approach would be to create virtual fields for PELL and FSEOG in the SA.acyr files.</div>
<div><br></div><div>Our entry for PEL.AMOUNT (our award code is only 3 characters) is:</div><div><div>001: I</div><div>002: SUBR('S.C26.IF.WHEN',SA.AWARD,'PEL',SA.AMOUNT)</div><div>003: MD2,</div><div>004: PEL.AMOUNT</div>
<div>005: 11R</div><div>006: S</div></div><div><br></div><div>The subroutine S.C26.IF.WHEN is quite short. Here is our insert file from CORE.INSERTS:</div><div><div>* SUBROUTINE S.C26.IF.WHEN(A.RETURN.VALUE,AL.LIST1,A.VALUE,AL.LIST2)</div>
<div>* </div><div>* INFO/BASIC SUBROUTINE</div><div>* 2/26/88</div><div>* Doug Sjoquist, Cedarville</div><div>* TITLE ----- IF.WHEN</div><div>*</div><div>*</div><div>* PURPOSE: RETRIEVE AN ITEM IN A MV ASSOC LIST (AL.LIST2) FOR THE</div>
<div>* ASSOCIATED POSITION OF A VALUE IN AL.LIST1</div><div>*</div><div>* Last updated by LIVE (SJOQUIST) at 11:25:55 on 02/26/1988.</div><div>*</div><div>********************************************************************</div>
<div>*<br></div><div><br></div><div> A.RETURN.VALUE = ''</div><div> NUM.VALUES = COUNT(A.VALUE,@VM) + 1</div><div> FOR VALUE.CTR=1 TO NUM.VALUES</div><div> SEARCH.VALUE = A.VALUE<1,VALUE.CTR></div>
<div> LOCATE SEARCH.VALUE IN AL.LIST1<1,1> SETTING VALUE.POS THEN</div><div> A.RETURN.VALUE = AL.LIST2<1,VALUE.POS></div><div> RETURN</div><div> END</div><div> NEXT VALUE.CTR</div>
<div> RETURN</div></div><div><br></div></div><div class="gmail_extra"><br clear="all"><div>David Rotman, Ph.D.<br>Associate Vice President for Technology<br>Chief Information Officer<br>Cedarville University<br>251 N. Main Street<br>
Cedarville, OH 45314<br><a href="mailto:rotmand@cedarville.edu" target="_blank">rotmand@cedarville.edu</a><br>voice 937-766-7905<br>fax 937-766-8819<div><img><br>
</div></div>
<br><br><div class="gmail_quote">On Tue, Dec 10, 2013 at 2:44 PM, Colwell, Kim <span dir="ltr"><<a href="mailto:kcolwell@dacc.edu" target="_blank">kcolwell@dacc.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div>Is it possible to put associated values in different columns on a single line?<br><br></div><div>In the following, I would like one line for each student, with the PELL amount in one column & the FSEOG amount in the next column, but it does not seem to be working ...<br>
</div><br><div><div><div>DOWNLOAD SA.<<Enter Award Year (YYYY):>> BY.EXP SA.AWARD \<br> @ID \<br> SA.LAST \<br> SA.FIRST \<br> SA.TERM.RES \<br> EVAL "IF SA.AWARD = 'PELL' THEN SA.AMOUNT ELSE ''" \<br>
EVAL "IF SA.AWARD = 'FSEOG' THEN SA.AMOUNT ELSE ''" \<br> HEADING \<br> LITERAL "Coll_ID" \<br> LITERAL "LastName" \<br> LITERAL "FirstName" \<br> LITERAL "Residency" \<br>
LITERAL "PELL" \<br> LITERAL "FSEOG" \<br> FORMAT CSV \<br>FILE _HOLD_ KCIPEDS-T3_<<Enter Term (YYYYSS):>>.csv OVERWRITING NO.PAGE<br><br><br></div><div>Thanks,<br><br></div><div>Kim Colwell<br>
</div><div>Danville Area Community College<br></div><div><a href="mailto:kcowlell@dacc.edu" target="_blank">kcowlell@dacc.edu</a><br><br></div></div></div></div>
<br>_______________________________________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu" target="_blank">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>
download-list mailing list<br>
<a href="mailto:download-list@cedarville.edu">download-list@cedarville.edu</a><br>
<a href="http://mail.cedarville.edu/mailman/listinfo/download-list" target="_blank">http://mail.cedarville.edu/mailman/listinfo/download-list</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><span style="color:rgb(0,0,153)">Kim Colwell</span><br>x8769<br></div>
</div>