No subject
Kogan, Arthur
akogan@westpac.com.au
Wed, 24 Mar 1999 09:40:34 +1100
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01BE757E.64F08FEE
Content-Type: text/plain
Hi Wanda.
What happens when you remove the line
set noduplicates
Please let us know.
Regards,
Arthur Kogan
Westpac Financial Services
Sydney, Australia
> -----Original Message-----
> From: Ravenscroft, Wanda L [SMTP:WandaL.Ravenscroft@Energizer.com]
> Sent: Wednesday, 24 March 1999 8:47 AM
> To: 'powerh-l@lists.swau.edu'
> Subject:
>
> Thanks to all of you who responded to my plea for help. I've poured over
> the manual and I've tried all the suggestions sent to me and I'm pretty
> much
> getting the same results as before. Somebody had asked if it was possible
> to get a copy of the source, here's the most current source with the
> results
> received below that. I'm sure it's something small that is getting by me,
> but for the life of me, I can't see it. Thanks again for any help
> received.
>
>
> set save clear
> cancel clear
>
> set report nolimit
>
> access *wmfast1 alias wmf
>
> set noduplicates
>
> sort on pm_prdtyp, pm_pc, sc2
>
> report summary &
> sc2 &
> pm_prdtyp of wmf &
> pm_pc of wmf &
> pm_asst_code of wmf &
> cvnc subtotal
>
> set subfile name wmfast2 at sc2 keep
>
>
>
> 412 30917 A 4010813
> 413 30917 A 4386797
> 414 30917 A 5765510
> 415 30917 A 22749072
> 470 30917 A 7949987
>
>
>
> On the line starting with 413, I should be getting:
>
> 413 30917 A 13429050
>
> which would be the total of:
>
> 413 30917 A 9042253
> 413 30917 A 4386797
>
>
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
------_=_NextPart_000_01BE757E.64F08FEE
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ig8WAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAFAAAAUkU6IADxAAEJgAEAIQAAADI5MjEwOTU0NkVFMUQy
MTE4ODRGMDAwMDgzNjgzNTY3AMEGASCAAwAOAAAAzwcDABgACQAqAA0AAwA0AQEFgAMADgAAAM8H
AwAYAAkAKAAiAAMARwEBDYAEAAIAAAACAAIAAQOQBgCkCgAAKwAAAAsAAgABAAAAAwAuAAAAAABA
ADkA4MJCKn51vgEeAHAAAQAAAAEAAAAAAAAAAgFxAAEAAAAbAAAAAb51en79eXGTbuFKEdKeHgAA
9rj6EQAAfrUgAAIBCRABAAAA3AUAANgFAABOCwAATFpGdaXJc30DAAoAcmNwZzEyNdIyAPszNgHo
IAKkA+MJAgBjaArAc2V0MP4gBxMCgwBQA9URaA5QEFbQcHJxMhFWfQqACMjsIDsJbw4wNRV/CmAC
gNkKgXVjAFALA2MAQQtgIm4OEDAzMwumIEiIaSBXAHBkYS4KojsKhAqAVxDgBUAQ4HBwkwnwBCB3
aAnwIHkIYIYgFuAEYHZlIHQcUHQgbAuAZRq6GMETMTHSIBERIG4EcHULUA3gPxuQB5AeJxIBAUAa
w1BsXGVhERAdcB8RdQQga0UfQHcaq1JlZwsRcx4sGroHEB1ACHAgS28vI0ALkBskB5B0CrBjILZG
C4AAcGMHMQZSdg3gyx/mBrBkHaB5LBFQIeD8dHIHQAcwHcsaxwswHYCfDzEYwSDBA2Af0GN0ExRQ
MTYgLSuyTwUQZwsmEQMgTQeQc2FnZT8rsxq2KsQgwwsxKsZpLRgxNDQBQB2AMTgwtwFADNAvU2Il
8ANhOgyDcmIRQFJhHRAAgAUAbwcBgCfgGlMgTCBbU5BNVFA6GlNMLjF5VEBFHaByLDB6BJAu+QWg
bV0atTCABmACMDDnmyWAJ6FzGoAn0TI0BdAjCsAQ0CAxOTfgIDgoOjQ3EVBNNTdUbxkw5ydwIjAE
kGgtbCZAHYAloHMuA+BhdRIuCYB1JzU4dWJq/yrxMOYtXy5qKhQM0AHBHoVLC9Qaw1QQ4G5rBCB0
/G8gB0ADIDHwHIMcQEEAPRbgczngGnAJgEDibXl2IAtQIVAgAhAFwBxQbMBwLiAgSScdETngdwhw
QoEdAXIatB1CA4F1/yZxGmFEBCgwCJBCkEEiHULYc3VnLOAloGkCIAQg3xEQAjBCox0gRiRtQwAW
4OsCQELwbRhAaBq0LOACQDULgGdHRGFI0UIRdWy3OqBBEAQgYgEQBbBlQ+HqUwNwZQbgZELwEOBG
8fxza0KBBpBOAAVAOuAEIPs54AQQaQJgHbVA8UqRQRD6IAWgcELwQWFHUwhhJvD3J+AcUBbgJ0DR
RYJOwAVA/mMIcBbgSHFQ5BwwTkA3sN8dQkulGrQW4CbwaR0QQpD/TFAJAAfgHUAbkEPjSWBHkH8W
4E4xUaFQ4AeAHUBK0nO/AMBHIxuRBABPskrDYknRc1EwGrRidQVAQ2IdRGa/HSBBYVkhRABQEABw
J1LB/wngTjFD4UCFLNALcUNTAHD/TVFDsRzBVNQaqxq0HwIswP0dEWMhQUUFW1Em8AMgYCm/XzgW
4DngACAfMR2AbU5ADxq6ANAm8QQgKndtZv0hYHQe4ChSHCFkwF7eH09PXyZiwgIgQwBtXxPQZO1J
wHAn4GjCYyfgBPAOUNcayWKVR5BtAMByQvBrv/dsz23fbkQmGrRuRmnhbk//cX9yj26/czZox0FS
ZLFzP/93P3NvdH4l4HXfe498n3jP93TmIWAloF8FoAEAen+A37OB729OY3YmQEeBYkDw/wGQCVBe
7jwALyAhQGawS2L/ZLQUABuRcEJN0GKgXn8bBQ2CATQOIIIBMzA5MTs4UIIJQYIDL3AZUDgxGxmA
iQgzib+KyDM4Nng3OTeI+TdQjJ+K1jXcNzYWoBlQiPk1j1+KxsAyMjc0OTABwIj4PjcRQJI/itaO
YJPgOTjzjoWXDwpPA6AdRh7wAZDfACBK0lNTjFFbEnNB4EvQ/1UiWGYw4B3aAZGMT4qKi6D0NDKT
8DU81xrSHEAN4P03sHeath1ChINBUZuvnL//iouT8J6gDjCLtaJPo1+OK/kauj0gqO+p/6sPrB+s
g48nJTwABPJMUDogIoRR964kRFE6BCJOAAOgB4EswqdMQE0yQrJhagWwZANwtm86bRq0VQCArgl1
sxj/r0+wU7D/sg457zr0WDMfwW064HlEoh2gLbnxQOJi91vxOnMmsS64BkAmWEE6cv9YMmAgTsAJ
gCfgJIFA006x/0iDHUQloCfgHJJJ8FIxmwFfMoC0BzTQGrQUkQDB0AMA/T9SAwAAHgBCEAEAAAA5
AAAAPEMxM0RERTY3Qjk2MEQyMTFCQ0VDMDAwMEY4N0FDM0JGODVFOUMzQFVTSFFMTVNFWENIRzAw
Mj4AAAAACwAAgAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAeACCAGAAAAAADAAAAAAAAA
RgAAAAAQhQAAAAAAAAMAI4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAB0EAAAHgAkgAggBgAAAAAA
wAAAAAAAAEYAAAAAVIUAAAEAAAAFAAAAOC4wMgAAAAADAA+ACCAGAAAAAADAAAAAAAAARgAAAAAB
hQAAAAAAAAsAKYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAMgAggBgAAAAAAwAAAAAAA
AEYAAAAAEYUAAAAAAAADACuACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AOoAIIAYAAAAA
AMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeADuACCAGAAAAAADAAAAAAAAARgAAAAA3hQAA
AQAAAAEAAAAAAAAAHgA8gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAMAJgAA
AAAAAwA2AAAAAAAeADFAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAAAwAaQAAAAAAeADBAAQAAAA8A
AABLT0dBTkE0RENCNzgzOAAAAwAZQAAAAAADAIAQ/////wIB+T8BAAAAYgAAAAAAAADcp0DIwEIQ
GrS5CAArL+GCAQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJ
TCBBRERSRVNTRVMvQ049S09HQU5BNERDQjc4MzgAAAAeAPg/AQAAAA4AAABLb2dhbiwgQXJ0aHVy
AAAAHgA4QAEAAAAPAAAAS09HQU5BNERDQjc4MzgAAAIB+z8BAAAAYgAAAAAAAADcp0DIwEIQGrS5
CAArL+GCAQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJTCBB
RERSRVNTRVMvQ049S09HQU5BNERDQjc4MzgAAAAeAPo/AQAAAA4AAABLb2dhbiwgQXJ0aHVyAAAA
HgA5QAEAAAAPAAAAS09HQU5BNERDQjc4MzgAAEAABzBgQUd5fHW+AUAACDDuj/BkfnW+AR4APQAB
AAAABQAAAFJFOiAAAAAAHgAdDgEAAAABAAAAAAAAAAsAKQAAAAAACwAjAAAAAAADAAYQ7qf4/AMA
BxAbBQAAAwAQEAAAAAADABEQAQAAAB4ACBABAAAAZQAAAEhJV0FOREFXSEFUSEFQUEVOU1dIRU5Z
T1VSRU1PVkVUSEVMSU5FU0VUTk9EVVBMSUNBVEVTUExFQVNFTEVUVVNLTk9XUkVHQVJEUyxBUlRI
VVJLT0dBTldFU1RQQUNGSU5BTkMAAAAAb+E=
------_=_NextPart_000_01BE757E.64F08FEE--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.