I want to build a code for SAS that allows me to input a file and then print it out in a specific format.
INFILE '/apps/dataapps15/projects/dinhch/artfile.txt' DELIMITER=',' dsd lrecl=400 pad missover;
INPUT ICN :$14.
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