求助高手！谢谢！！

shiyiming

数据如下：(从Excel复制的数据，倒为SAS后date格式变为datetime20.,cardid格式为$16.)
0010010000000001 2006-8-10 13:32:57
0010010000000001 2006-8-12 15:53:16
0010010000000001 2006-8-14 14:08:28
0010010000000001 2006-8-15 19:28:41
0010010000000001 2006-8-15 22:31:28
0010010000000001 2006-8-20 12:17:16
0010010000000001 2006-8-20 13:35:07
0010010000000001 2006-8-20 13:43:48
0010010000000001 2006-8-20 14:03:07
0010010000000001 2006-8-23 15:22:38
0010010000000001 2006-8-29 13:46:53
0010010000000001 2006-8-30 21:00:04
0010010000000001 2006-9-1 21:47:03
0010010000000001 2006-9-1 23:15:41
0010010000000001 2006-9-5 12:34:00
0010010000000001 2006-9-9 18:24:52
0010010000000001 2006-9-14 13:37:21
0010010000000001 2006-9-15 20:58:08
0010010000000001 2006-9-21 09:02:32
0010010000000001 2006-9-21 14:07:32
0010010000000001 2006-9-26 10:13:08
0010010000000001 2006-9-26 21:53:56
0010010000000001 2006-10-12 20:41:52
0010010000000001 2006-10-13 14:47:33
0010010000000001 2006-10-17 11:27:28
0010010000000001 2006-10-17 16:14:34
0010010000000001 2006-10-18 12:52:45
0010010000000001 2006-10-27 16:54:15
0010010000000001 2006-10-28 16:01:44
0010010000000002 2006-8-24 13:02:04
0010010000000002 2006-8-24 13:05:13
0010010000000002 2006-9-2 15:33:47
0010010000000002 2006-9-14 13:11:05
0010010000000002 2006-9-25 13:24:35
0010010000000011 2006-8-11 22:27:14
0010010000000011 2006-8-11 22:30:52
0010010000000011 2006-9-8 14:12:08
0010010000000011 2006-9-14 14:56:12
0010010000000011 2006-9-20 14:23:55
0010010000000011 2006-9-29 14:37:21
0010010000000011 2006-10-27 16:27:41
0010010000000324 2006-8-23 12:22:36
0010010000000340 2006-8-13 11:18:50
0010010000000341 2006-8-13 11:24:13
0010010000000341 2006-8-27 16:13:10
0010010000000341 2006-8-27 16:48:44
0010010000000342 2006-8-13 11:18:20
0010010000000343 2006-8-13 11:06:26
0010010000000343 2006-8-19 09:57:03
0010010000000343 2006-8-24 13:07:21
0010010000000344 2006-8-13 11:27:23
0010010000000344 2006-8-27 16:13:52
0010010000000344 2006-8-27 16:39:58
0010010000000345 2006-8-13 11:28:43
0010010000000345 2006-8-17 11:46:39
0010010000000345 2006-8-24 13:06:35
0010010000000346 2006-8-13 11:25:01
0010010000000346 2006-8-27 16:27:24
0010010000000346 2006-8-27 16:38:14
0010010000000346 2006-9-28 19:41:48
0010010000000347 2006-8-13 11:17:17
0010010000000348 2006-8-13 11:17:52
0010010000000349 2006-8-13 11:26:34
0010010000000349 2006-8-13 20:16:50
0010010000000349 2006-8-27 16:11:22
0010010000000349 2006-8-27 16:47:11
0010010000000350 2006-8-13 11:11:56
0010010000000351 2006-8-13 11:21:49
0010010000000353 2006-8-13 11:21:21
0010010000000354 2006-8-13 11:25:48
0010010000000354 2006-8-27 16:12:27
0010010000000354 2006-8-27 16:43:49
0010010000000355 2006-8-13 11:11:25
0010010000000356 2006-8-13 11:10:51
0010010000000357 2006-8-13 11:28:05
0010010000000357 2006-8-27 16:10:17
0010010000000357 2006-8-27 16:41:38
0010010000000357 2006-10-1 18:15:12
0010010000000357 2006-10-1 18:23:28
0010010000000391 2006-8-28 19:33:20
0010010000000391 2006-9-7 13:41:32
0010010000000391 2006-10-7 17:10:03
0010010000000391 2006-10-7 18:48:31
0010010000000415 2006-8-13 11:06:54
0010010000000415 2006-8-19 09:55:43
0010010000000415 2006-8-24 13:07:57
0010010000000424 2006-9-21 20:30:03
0010010000000424 2006-9-21 20:32:17
0010010000000428 2006-8-24 15:57:40
0010010000000428 2006-8-28 15:56:04
0010010000000428 2006-9-12 11:12:19
0010010000000428 2006-9-29 11:21:13
0010010000000428 2006-9-29 12:16:03
0010010000000428 2006-10-10 16:40:26
0010010000000466 2006-8-13 18:14:03
0010010000000466 2006-9-1 23:46:09
0010010000000466 2006-9-2 23:17:33
0010010000000504 2006-10-1 12:48:18
0010010000000504 2006-10-1 12:51:44
0010010000000504 2006-10-8 12:45:33
0010010000000504 2006-10-12 20:38:29
0010010000000504 2006-10-13 15:09:36
0010010000000513 2006-8-16 12:45:50
0010010000000513 2006-8-16 19:05:15
0010010000000513 2006-8-17 12:32:11
0010010000000513 2006-8-30 12:45:28
0010010000000513 2006-9-2 19:32:40
0010010000000513 2006-9-12 18:38:03
0010010000000608 2006-9-3 19:26:07
0010010000000608 2006-9-17 14:20:54
0010010000000611 2006-8-27 20:26:20
0010010000000611 2006-8-28 19:12:24
0010010000000611 2006-8-31 21:24:14
0010010000000611 2006-10-27 20:59:01
0010010000000614 2006-10-2 09:53:51
0010010000000626 2006-10-23 17:03:30
0010010000000627 2006-8-18 21:06:18
0010010000000627 2006-9-8 12:03:02
0010010000000627 2006-9-20 12:28:17
0010010000000627 2006-9-20 12:33:10
0010010000000627 2006-9-27 12:46:57
0010010000000630 2006-10-9 18:59:05
0010010000000630 2006-10-10 12:20:47
0010010000000630 2006-10-23 17:49:22
0010010000000631 2006-10-10 12:19:19
0010010000000631 2006-10-11 14:28:25
0010010000000631 2006-10-26 10:09:30
0010010000000633 2006-8-17 12:33:17
0010010000000633 2006-8-24 19:24:11
0010010000000633 2006-10-9 11:33:48
0010010000000633 2006-10-12 19:16:23
0010010000000633 2006-10-13 19:03:43
0010010000000633 2006-10-16 12:36:08
0010010000000633 2006-10-22 21:24:12
0010010000000636 2006-8-12 19:51:24
0010010000000636 2006-8-16 12:44:59
0010010000000636 2006-8-17 12:31:08
0010010000000636 2006-8-30 12:44:15
0010010000000636 2006-9-5 20:12:44
0010010000000636 2006-9-18 18:27:06
0010010000000636 2006-9-19 08:36:25
0010010000000636 2006-9-20 08:35:21
0010010000000636 2006-9-21 08:50:46
0010010000000636 2006-9-30 12:46:51
0010010000000636 2006-10-8 13:10:26
0010010000000636 2006-10-11 20:14:22
0010010000000636 2006-10-17 18:47:01
0010010000000636 2006-10-19 13:08:52
0010010000000650 2006-8-17 12:30:09
0010010000000650 2006-9-14 12:43:49
0010010000000650 2006-10-19 20:05:12
0010010000000678 2006-8-18 15:46:10
0010010000000678 2006-8-18 15:51:03
0010010000000678 2006-8-21 18:23:26
0010010000000678 2006-8-21 18:26:53
0010010000000768 2006-8-12 12:46:22
0010010000000784 2006-10-8 19:00:25
0010010000000784 2006-10-8 19:02:44
0010010000000784 2006-10-8 19:04:19
0010010000000786 2006-10-1 14:46:21
0010010000000786 2006-10-2 21:25:33
0010010000000786 2006-10-3 21:01:32
0010010000000786 2006-10-16 20:40:40
0010010000000791 2006-10-24 15:57:44
0010010000000791 2006-10-27 18:18:40
0010010000000797 2006-10-3 21:14:43
0010010000000797 2006-10-11 19:10:11
0010010000000797 2006-10-17 20:50:09
0010010000000798 2006-10-9 16:35:35
0010010000000798 2006-10-14 13:24:11
0010010000000798 2006-10-20 13:01:36
0010010000000801 2006-9-14 09:14:04
0010010000000801 2006-10-10 19:41:48
0010010000000805 2006-8-21 19:24:38
0010010000000806 2006-10-15 21:01:29
0010010000000807 2006-10-10 20:20:11
0010010000000807 2006-10-11 19:47:19
0010010000000807 2006-10-13 21:33:46
0010010000000808 2006-8-22 22:51:56
0010010000000808 2006-8-23 13:58:59
0010010000000810 2006-10-8 16:01:13
0010010000000810 2006-10-11 21:13:17
0010010000000811 2006-9-22 18:19:38
0010010000000825 2006-10-9 20:49:24
0010010000000825 2006-10-16 20:25:46
0010010000000830 2006-8-12 16:10:17
0010010000000830 2006-8-20 21:55:51
0010010000000830 2006-10-14 14:39:31
0010010000000830 2006-10-28 12:41:22
0010010000000830 2006-10-28 16:37:33
0010010000000830 2006-10-28 22:27:00
0010010000000835 2006-8-14 14:56:52
0010010000000835 2006-8-14 16:28:56
0010010000000835 2006-8-14 16:45:01
0010010000000835 2006-8-30 21:27:51
0010010000000835 2006-8-30 21:31:50
0010010000000835 2006-10-2 13:36:42
0010010000000835 2006-10-18 12:38:33
0010010000000886 2006-8-15 13:52:46
0010010000000886 2006-8-17 13:40:29
0010010000000886 2006-8-21 13:41:38
0010010000000886 2006-8-22 13:13:29
0010010000000886 2006-10-10 14:39:44
0010010000000886 2006-10-23 13:06:41
0010010000000886 2006-10-25 12:51:09
0010010000000889 2006-8-25 12:07:37
0010010000000889 2006-10-20 21:32:15
0010010000000978 2006-10-3 14:08:54
0010010000000982 2006-9-16 09:49:50
0010010000000982 2006-9-16 09:52:50
0010010000000982 2006-9-23 01:45:25
0010010000000984 2006-8-25 11:46:56
0010010000000984 2006-8-26 10:44:59
0010010000000984 2006-9-10 14:36:31
0010010000000984 2006-10-21 15:20:57
0010010000000990 2006-8-27 16:13:06
0010010000000995 2006-8-18 15:36:27
0010010000000995 2006-10-3 16:10:11
0010010000000995 2006-10-3 17:43:17
0010010000000995 2006-10-6 20:05:38
0010010000000995 2006-10-6 20:12:01
0010010000000995 2006-10-6 20:14:30
0010010000000996 2006-8-14 19:27:15
0010010000000996 2006-8-14 19:30:09
0010010000000996 2006-10-15 14:37:05
0010010000000997 2006-10-28 17:17:01
0010010000000997 2006-10-28 17:41:24
0010010000001003 2006-8-26 19:19:43
0010010000001003 2006-10-2 18:41:30
0010010000001003 2006-10-4 18:03:57
0010010000001006 2006-10-28 15:35:23
0010010000001007 2006-8-30 12:28:14
0010010000001007 2006-10-14 19:04:19
0010010000001007 2006-10-20 19:53:52
0010010000001011 2006-10-8 14:01:00
0010010000001011 2006-10-8 14:42:07
0010010000001025 2006-10-2 22:08:09
0010010000001025 2006-10-2 22:11:52
0010010000001025 2006-10-12 21:09:05
0010010000001025 2006-10-15 20:06:45
0010010000001025 2006-10-21 19:24:39
0010010000001065 2006-10-7 11:07:52
0010010000001065 2006-10-7 14:11:30
0010010000001101 2006-10-16 20:41:57
0010010000001102 2006-9-13 11:57:34
0010010000001102 2006-9-30 21:36:03
0010010000001102 2006-10-5 23:04:11
0010010000001131 2006-10-25 22:44:56
0010010000001134 2006-9-13 19:52:59
0010010000001138 2006-10-22 14:44:32
0010010000001138 2006-10-24 21:55:46
0010010000001138 2006-10-28 20:36:21
0010010000001139 2006-10-3 12:37:50
0010010000001505 2006-10-12 20:37:53
0010010000001505 2006-10-13 15:17:12
0010010000001509 2006-10-7 18:46:45
0010010000001509 2006-10-22 18:50:19
0010010000001516 2006-10-5 18:42:20
0010010000001516 2006-10-9 12:42:47
0010010000001516 2006-10-16 12:37:28
0010010000001556 2006-10-15 16:54:02
0010010000001558 2006-10-7 18:36:11
0010010000001558 2006-10-10 14:33:42
0010010000001558 2006-10-10 16:42:45
0010010000001558 2006-10-12 10:41:01
0010010000001558 2006-10-24 11:16:14
0010010000001566 2006-10-8 20:34:52
0010010000001566 2006-10-11 13:08:56
0010010000001598 2006-10-10 20:38:58
0010010000001980 2006-10-1 18:40:25
0010010000001980 2006-10-5 15:45:12
0010010000001980 2006-10-5 19:22:27
0010010000001980 2006-10-11 18:59:09
0010010000001982 2006-8-16 12:43:52
0010010000001982 2006-8-21 19:40:50
0010010000001982 2006-10-28 15:52:29
0010010000002004 2006-8-13 11:47:07
0010010000002004 2006-8-13 11:49:57
0010010000002004 2006-9-17 17:31:17
0010010000002004 2006-10-7 21:15:08
0010010000002005 2006-8-30 12:28:55
0010010000002005 2006-10-18 13:07:28
0010010000002006 2006-8-14 21:04:11
0010010000002007 2006-9-30 17:34:54
0010010000002007 2006-10-12 14:32:52
0010010000002008 2006-8-13 22:06:42
0010181600380002 2006-10-7 16:24:59
0010181600380002 2006-10-7 16:25:46
0010181600380002 2006-10-7 16:30:13
0010181600380003 2006-10-14 18:10:16
0010181600380006 2006-10-7 23:41:59
0010181600380006 2006-10-12 18:09:45
0010181600380006 2006-10-15 10:12:33
0010181600380008 2006-10-15 13:29:35
0010181600380011 2006-10-28 18:09:10
0010181600380012 2006-10-7 21:08:48
0010181600380012 2006-10-7 22:35:57
0010181600380012 2006-10-8 00:04:12
0010181600380012 2006-10-8 00:25:08
0010181600380012 2006-10-17 10:38:13
0010181600380020 2006-10-14 09:53:37
0010181600380024 2006-10-14 10:34:10
0010181600380024 2006-10-15 15:31:51
0010181600380027 2006-10-14 13:46:30
0010181600380027 2006-10-25 11:56:39
0010181600380028 2006-10-14 15:47:48
0010181600380028 2006-10-14 17:37:05
0010181600380028 2006-10-15 19:32:06
0010181600380028 2006-10-21 17:10:11
0010181600380028 2006-10-21 17:11:04
0010181600380028 2006-10-26 13:53:16
0010181600380029 2006-10-14 16:43:12
0010181600380029 2006-10-14 16:49:38
0010181600380029 2006-10-21 15:27:45
0010181600380029 2006-10-22 13:15:07
0010181600380030 2006-10-15 11:05:41
0010181600380031 2006-10-15 12:19:21
0010181600380033 2006-10-16 10:47:56
0010181600380037 2006-10-15 12:44:09
0010181600380037 2006-10-18 18:42:45
0010181600380037 2006-10-21 10:20:26
0010181600380041 2006-10-24 11:35:29
0010181600380041 2006-10-28 15:35:37
0010181600380045 2006-10-16 16:19:03
0010181600380045 2006-10-19 11:20:28
0010181600380045 2006-10-20 09:58:13
0010181600380045 2006-10-20 11:00:11
0010181600380045 2006-10-28 10:52:59
0010181600380045 2006-10-28 11:47:00
0010181600380046 2006-10-16 14:59:44
0010181600380047 2006-10-16 16:18:22
0010181600380049 2006-10-18 15:11:51
0010181600380052 2006-10-18 17:47:22
0010181600380052 2006-10-24 14:33:41
0010181600380052 2006-10-28 11:38:25
0010181600380053 2006-10-20 13:06:36
0010181600380055 2006-10-21 11:55:04
0010181600380056 2006-10-23 17:11:32
0010181600380057 2006-10-21 12:38:16
0010181600380062 2006-10-8 12:45:31
0010181600380063 2006-10-8 14:48:30
0010181600380065 2006-10-8 18:12:44
0010181600380065 2006-10-8 18:12:58
第一个变量为cardid ,第二个为time。time变成这样了（10AUG2006:13:32:57)
现在的要求是统计卡第一次使用与第二次使用的时间间隔（只需要到日期，不考虑日期以后的具体时间，卡多次使用只考虑前两次）。
所以最后需要的结果是两次使用间隔时间0天的卡多少张，是间隔时间1天的卡多少张，是间隔时间2天的卡多少张.....间隔时间7天以上的多少张
谢谢！急啊！大家帮我啊！

shiyiming

便于计算,先在EXCEL中把你的数据中第二列time去掉时间后转成数值型
如:2006-8-10 13:32:57  变为38939   变量名为date

proc sort data=a;by cardid;
proc transpose data=a out=b prefix=dat;
by cardid;
var date;
run;
data b1;set b;keep id dat1 dat2 d;
if dat2=. then delete;
d=dat2-dat1;if d>7 then d=7;
proc freq;tables d;run;

shiyiming

谢谢你的解答！感谢！！

shiyiming

proc sort data=a;
  by cardid date;
run;
proc transpose data=a out=b prefix=dat;
  by cardid;
  var date;
run;
data b1;
  set b;
  keep cardid d;
  d=min(dat2-dat1,7);
  if d>.;
run;
proc freq;
  tables d;
run;

shiyiming

本例中考虑暂时没有使用第二次的卡可分为两类，一类是使用间隔会在7天以上，一类是永远也不会再使用。

shiyiming

谢谢大家的解答！受益匪浅！！