Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
DATA breas.art; INFILE '/apps/dataapps15/projects/dinhch/artfile.txt' DELIMITER=',' dsd lrecl=400 pad missover; INPUT ICN :$14. ICN_VRSN :8. DOC_ID :$15. ADJKEY :$8. TTL_CHRG :13.2 PDATE :$8. ADJ_TYPE_CD :$2. ADJ_RSN_CD :$3. UPD_USER :$8. TTL_PAID_AMNT :13.2 FUND_CODE :$13. FUND :$154.; Group by the ADJKEY , count the ICN and sum up the TTL_Paid_amnt Print it out example, the result file would be ADJKEY Count Sum