[Robelle-l] DEFINE question
Eben Yong
eben_yong@hpsm.org
Wed, 19 Nov 2003 12:23:49 -0800
This is a multi-part message in MIME format.
------_=_NextPart_001_01C3AEDB.0AC297B1
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: base64
SSBoYXZlIHNvdXJjZSBkYXRhIHRoYXQgbG9va3MgbGlrZSB0aGlzOg0KDQogDQoNCjAwQTIyMzU3
MSAwMDAzODQyNzYrDQoNCjAwQTIyNzE2MCAwMDAxOTM0OTUrDQoNCjAwQTIzOTYyMCAwMDAyNTM3
NDArDQoNCjAwQTI5OTI4MSAwMDAyODI0NDkrDQoNCjAwQTM3NjY3MCAwMDAxNDcwMzArDQoNCiAN
Cg0KVGhlIGxheW91dDogIA0KDQogWDEwIGtleS1maWVsZA0KDQogWDEwIG51bWVyaWMtZGF0YQ0K
DQogDQoNCkknZCBsaWtlIHRvIGFnZ3JlZ2F0ZSB0aGUgbnVtZXJpYyBkYXRhIGJhc2VkIG9uIHRo
ZSBrZXkgZmllbGQuICBJIHRyaWVkDQp0byBkbyBzb21ldGhpbmcgbGlrZSB0aGlzLCBidXQgaXQg
ZG9lc24ndCBwYXJzZSB0aGUgdHJhaWxpbmcgUExVUyBzeW1ib2wNCnByb3Blcmx5LiAgQW55IGhl
bHAgd291bGQgYmUgYXBwcmVjaWF0ZWQuICBUaGFua3MhDQoNCiANCg0KSW4gaW5maWxlDQoNCkRl
ZiBrZXktZmllbGQsMSwxMA0KDQpEZWYgbnVtZXJpYy1kYXRhLDExLDEwLGRpc3BsYXkNCg0KTyB4
MSx0ZW0sbGluDQoNClgNCg0KIA0KDQpJbiB4MQ0KDQpTb3Iga2V5LWZpZWxkDQoNCkV4dCBrZXkt
ZmllbGQNCg0KRHVwIG4gayB0IG51bWVyaWMtZGF0YQ0KDQpPIHgyLHRlbSxsaW4NCg0KeA0KDQog
DQoNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCg0KRWJlbiBZb25nDQoN
Ck1JUyBNYW5hZ2VyDQoNCkhlYWx0aCBQbGFuIG9mIFNhbiBNYXRlbw0KDQo3MDEgR2F0ZXdheSBC
bHZkDQoNClNvdXRoIFNhbiBGcmFuY2lzY28sIENBICA5NDA4MA0KDQpURUw6NjUwLTYxNi0yMDEw
DQoNCkZBWDo3MDctMjgxLTI2OTENCg0Kd3d3Lmhwc20ub3JnDQoNCmViZW5feW9uZ0BocHNtLm9y
Zw0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tIA0KICANCkNPTkZJREVO
VElBTElUWSBOT1RJQ0U6ICBUaGlzIGUtbWFpbCwgaW5jbHVkaW5nIGF0dGFjaG1lbnRzLCBpcyBm
b3IgdGhlIA0Kc29sZSB1c2Ugb2YgdGhlIGluZGl2aWR1YWwocykgdG8gd2hvbSBpdCBpcyBhZGRy
ZXNzZWQsIGFuZCBtYXkgY29udGFpbiANCmNvbmZpZGVudGlhbCBhbmQgcHJpdmlsZWdlZCBpbmZv
cm1hdGlvbi4gQW55IHVuYXV0aG9yaXplZCByZXZpZXcsIHVzZSwgDQpkaXNjbG9zdXJlLCBkaXN0
cmlidXRpb24sIG9yIHJlcHJvZHVjdGlvbiBpcyBwcm9oaWJpdGVkLiBJZiB5b3UgaGF2ZSANCnJl
Y2VpdmVkIHRoaXMgZS1tYWlsIGluIGVycm9yLCBwbGVhc2Ugbm90aWZ5IHRoZSBzZW5kZXIgYnkg
cmVwbHkgZS1tYWlsIA0KYW5kIGRlc3Ryb3kgdGhpcyBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVu
dHMuIFRoYW5rIHlvdSBmb3IgeW91ciANCmNvb3BlcmF0aW9uLiAgDQogDQo=
------_=_NextPart_001_01C3AEDB.0AC297B1
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16">
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* 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
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</HEAD><BODY lang=3DEN-US link=3Dblue vlink=3Dpurple><DIV>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I have source data that looks like =
this:</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>00A223571 000384276+</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>00A227160 000193495+</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>00A239620 000253740+</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>00A299281 000282449+</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>00A376670 000147030+</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>The layout: </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> X10 key-field</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> X10 numeric-data</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I’d like to aggregate the numeric data based on =
the
key field. I tried to do something like this, but it doesn’t =
parse
the trailing PLUS symbol properly. Any help would be =
appreciated.
Thanks!</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>In infile</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Def key-field,1,10</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Def numeric-data,11,10,display</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>O x1,tem,lin</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>X</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>In x1</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Sor key-field</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Ext key-field</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Dup n k t numeric-data</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>O x2,tem,lin</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>x</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>-------------------------------------</span></font></p=
>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Eben Yong</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>MIS Manager</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Health Plan of </span></font><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>San =
Mateo</span></font></p>
<p class=3DMsoNormal><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>701
Gateway Blvd</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>South San Francisco</span></font><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>, </span></font><font =
size=3D2
face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>CA</span></font><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'> </span></font><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>94080</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>TEL:650-616-2010</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>FAX:707-281-2691</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><a =
href=3D"http://www.hpsm.org">www.hpsm.org</a></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'><a =
href=3D"mailto:eben_yong@hpsm.org">eben_yong@hpsm.org</a></span></font></=
p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>-------------------------------------</span></font></p=
>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'> </span></font></p>
</div>
</DIV>
<DIV> </DIV>
<DIV>
<DIV>
<FONT SIZE=3D"2">CONFIDENTIALITY NOTICE: This e-mail, including =
attachments, is for the</FONT><BR><FONT SIZE=3D"2">sole use of the =
individual(s) to whom it is addressed, and may contain</FONT><BR><FONT =
SIZE=3D"2">confidential and privileged information. Any unauthorized =
review, use,</FONT><BR><FONT SIZE=3D"2">disclosure, distribution, or =
reproduction is prohibited. If you have</FONT><BR><FONT =
SIZE=3D"2">received this e-mail in error, please notify the sender by =
reply e-mail</FONT><BR><FONT SIZE=3D"2">and destroy this message and its =
attachments. Thank you for your</FONT><BR><FONT SIZE=3D"2">cooperation. =
</FONT>
</DIV>
</DIV></BODY></HTML>
------_=_NextPart_001_01C3AEDB.0AC297B1--