表示这个PSM的macro跑了5小时都没停...

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

http://www.pharmasug.org/proceedings/2015/HA/PharmaSUG-2015-HA05.pdf

用的是上面这个macro，结果...
NOTE: There were 2148 observations read from the data set WORK.PSTREATMENT.
NOTE: The data set WORK.__PATMATCH has 2148 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds



NOTE: There were 8571 observations read from the data set WORK.PSCONTROL.
NOTE: The data set WORK.__CONTMATCH has 8571 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.03 seconds


NOTE: The execution of this query involves performing one or more Cartesian product joins that
      can not be optimized.
NOTE: Table WORK.__MATCHES0 created, with 7445038 rows and 4 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           6.49 seconds
      cpu time            7.89 seconds



NOTE: There were 7445038 observations read from the data set WORK.__MATCHES0.
NOTE: The data set WORK.__POSSIBLE_MATCHES has 7445037 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           7.79 seconds
      cpu time            3.08 seconds



NOTE: There were 7445037 observations read from the data set WORK.__POSSIBLE_MATCHES.
NOTE: The data set WORK.__MATCHFREQ has 2147 observations and 2 variables.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           3.24 seconds
      cpu time            2.71 seconds



NOTE: There were 7445037 observations read from the data set WORK.__POSSIBLE_MATCHES.
NOTE: There were 2147 observations read from the data set WORK.__MATCHFREQ.
NOTE: The data set WORK.__MATCHES_FREQ0 has 7445037 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           20.02 seconds
      cpu time            4.15 seconds



NOTE: There were 7445037 observations read from the data set WORK.__POSSIBLE_MATCHES.
NOTE: The data set WORK.__CNTLFREQ has 8571 observations and 2 variables.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           3.72 seconds
      cpu time            3.61 seconds



NOTE: There were 7445037 observations read from the data set WORK.__MATCHES_FREQ0.
NOTE: The data set WORK.__MATCHES_FREQ0 has 7445037 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           28.44 seconds
      cpu time            9.25 seconds



NOTE: There were 7445037 observations read from the data set WORK.__MATCHES_FREQ0.
NOTE: There were 8571 observations read from the data set WORK.__CNTLFREQ.
NOTE: The data set WORK.__MATCHES_FREQ has 7445037 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           7.13 seconds
      cpu time            3.68 seconds



NOTE: Deleting WORK.__MATCHES0 (memtype=DATA).

NOTE: PROCEDURE DATASETS used (Total process time):
      real time           1.70 seconds
      cpu time            0.06 seconds



NOTE: There were 7445037 observations read from the data set WORK.__MATCHES_FREQ.
NOTE: The data set WORK.__MATCHES_FREQ has 7445037 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           32.12 seconds
      cpu time            13.94 seconds



NOTE: There were 7445037 observations read from the data set WORK.__MATCHES_FREQ.
NOTE: The data set WORK.__FIRST_PAT_IDVAR has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           1.24 seconds
      cpu time            1.20 seconds



NOTE: There were 7445037 observations read from the data set WORK.__MATCHES_FREQ.
NOTE: The data set WORK.__MATCHES_FREQ has 7445037 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           30.13 seconds
      cpu time            11.29 seconds



NOTE: There were 7445037 observations read from the data set WORK.__MATCHES_FREQ.
NOTE: There were 1 observations read from the data set WORK.__FIRST_PAT_IDVAR.
NOTE: The data set WORK.__ALL_FIRST_ID has 1 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           1.66 seconds
      cpu time            1.52 seconds



NOTE: There were 1 observations read from the data set WORK.__ALL_FIRST_ID.
NOTE: The data set WORK.__NEW_MATCHED_PAIRS has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds



NOTE: There were 1 observations read from the data set WORK.__NEW_MATCHED_PAIRS.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.__NEW_MATCHED_PATS has 1 observations and 1 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           1.18 seconds
      cpu time            0.01 seconds



NOTE: There were 7445037 observations read from the data set WORK.__POSSIBLE_MATCHES.
NOTE: There were 1 observations read from the data set WORK.__NEW_MATCHED_PATS.
NOTE: The data set WORK.__MATCH_REMOVE_PAT has 7445036 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           42.28 seconds
      cpu time            4.72 seconds



NOTE: There were 1 observations read from the data set WORK.__NEW_MATCHED_PAIRS.
NOTE: The data set WORK.__REMOVE_CONT has 1 observations and 1 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.14 seconds
      cpu time            0.01 seconds



NOTE: There were 7445036 observations read from the data set WORK.__MATCH_REMOVE_PAT.
NOTE: The data set WORK.__MATCH_REMOVE_PAT has 7445036 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           12.89 seconds
      cpu time            9.08 seconds



NOTE: There were 7445036 observations read from the data set WORK.__MATCH_REMOVE_PAT.
NOTE: There were 1 observations read from the data set WORK.__REMOVE_CONT.
NOTE: The data set WORK.__MATCH_REMOVE_CONT has 7445009 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           5.66 seconds
      cpu time            3.93 seconds



NOTE: There were 7445009 observations read from the data set WORK.__MATCH_REMOVE_CONT.
NOTE: The data set WORK.__POSSIBLE_MATCHES has 7445009 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           27.56 seconds
      cpu time            9.34 seconds



NOTE: Appending WORK.__NEW_MATCHED_PAIRS to WORK.__FINAL_MATCHED_PAIRS.
NOTE: BASE data set does not exist. DATA file is being copied to BASE file.
NOTE: There were 1 observations read from the data set WORK.__NEW_MATCHED_PAIRS.
NOTE: The data set WORK.__FINAL_MATCHED_PAIRS has 1 observations and 4 variables.
NOTE: PROCEDURE APPEND used (Total process time):
      real time           2.78 seconds
      cpu time            0.01 seconds



NOTE: There were 7445009 observations read from the data set WORK.__POSSIBLE_MATCHES.
NOTE: The data set WORK.__MATCHFREQ has 2144 observations and 2 variables.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           3.10 seconds
      cpu time            2.73 seconds



NOTE: There were 7445009 observations read from the data set WORK.__POSSIBLE_MATCHES.
NOTE: There were 2144 observations read from the data set WORK.__MATCHFREQ.
NOTE: The data set WORK.__MATCHES_FREQ0 has 7445009 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           7.80 seconds
      cpu time            3.97 seconds



NOTE: There were 7445009 observations read from the data set WORK.__POSSIBLE_MATCHES.
NOTE: The data set WORK.__CNTLFREQ has 8570 observations and 2 variables.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           3.56 seconds
      cpu time            3.44 seconds



NOTE: There were 7445009 observations read from the data set WORK.__MATCHES_FREQ0.
NOTE: The data set WORK.__MATCHES_FREQ0 has 7445009 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           18.41 seconds
      cpu time            8.69 seconds

他就各种循环的要跪了。。。。。大家知道怎么回事么

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Macro acr CRO Mac PSM

If the macro takes a very long time to run without completion, the chosen value of the allowable radius (SCORE_DIFF) is probably too large for the input data, and a smaller radius should be used.