One to many isn't a problem.  Many to many is most easily accomplished with proc sql.  Take a look at: http://support.sas.com/techsup/technote/ts705.pdf and the other references that article provides. ... View more

Have you tried preceding your proc import with: options datestyle DMY; Art ... View more

How about: options datestyle=mdy; data temp; input obs datetime : anydtdtm20. id ; minute=minute(datetime); format datetime datetime.; datalines; 1  6/8/2011:00:00:30 1 2  6/8/2011:00:00:15 1 3  6/8/2011:00:01:00 1 4  6/8/2011:00:01:50 1 5  6/8/2011:00:01:10 1 6  6/8/2011:00:01:30 1 7  6/8/2011:00:02:00 1 8  6/8/2011:00:02:44 1 9  6/8/2011:00:00:17 1 10  6/8/2011:00:02:10 1 11  6/8/2011:00:03:21 1 12  6/8/2011:00:04:00 1 ; run; proc sort data=temp; by minute; run; data want; set temp; by minute; retain count; if first.minute then count=0; count+1; if last.minute then output; run; Ksharp ... View more