options ls=80 nocenter;
libname mystuff '.';
libname library '.';
filename myfiles pipe "cat *.csv";

data mystuff.atla (drop=unix_secs sysuptime engine_type 
   engine_id exaddr src_mask dst_mask first last);
   length srcaddr dstaddr exaddr nexthop $ 15;
   length node $ 6;
   format src_as dst_as as.;
   format nexthop $nexthop.;
   format prot protocol.;
   format tcp_flags flags.;
   infile myfiles dlm=',' firstobs=2 missover;
   input unix_secs 
         unix_nsecs 
         sysuptime 
         exaddr :$
         dpkts 
         doctets 
         first 
         last 
         engine_type
         engine_id 
         srcaddr :$
         dstaddr :$
         nexthop :$
         input 
         output 
         srcport 
         dstport 
         prot 
         tos 
         tcp_flags 
         src_mask 
         dst_mask 
         src_as 
         dst_as;
   time=last-first;
   if time>0 then speed=doctets/time; else speed=.;

   node='ATLA';

run;