{"id":323,"date":"2017-09-29T21:01:15","date_gmt":"2017-09-29T12:01:15","guid":{"rendered":"https:\/\/plaza.umin.ac.jp\/~OIO\/?p=323"},"modified":"2017-10-29T11:35:05","modified_gmt":"2017-10-29T02:35:05","slug":"analysis-specification-for-sccs","status":"publish","type":"post","link":"https:\/\/plaza.umin.ac.jp\/~OIO\/?p=323","title":{"rendered":"Analysis Specification for SCCS"},"content":{"rendered":"<p><a href=\"https:\/\/plaza.umin.ac.jp\/~OIO\/blog\/2017\/09\/28\/self-controlled-case-series-sccs-2\/\">\u5148\u65e5\u306e\u89e3\u6790<\/a>\u3067\u4f7f\u7528\u3057\u305fSQL \u30b9\u30af\u30ea\u30d7\u30c8\u3067\u3059<\/p>\n<table width=\"1026\">\n<tbody>\n<tr>\n<td width=\"78\"><strong>\u30b3\u30de\u30f3\u30c9<\/strong><\/td>\n<td width=\"330\"><strong>\u30d5\u30a3\u30fc\u30eb\u30c9\u540d<\/strong><\/td>\n<td width=\"618\"><strong>\u8ffd\u52a0\u5143\u30fb\u66f4\u65b0\u5143<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0010 SCCS_preprocess q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">547 AS age<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.start<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.end<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.exday<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[exday]+14 AS ex1<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[exday]+35 AS ex2<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[ex1]-[start] AS l1a1<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[age]-[start] AS l1a2<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">IIf([l1a1]&gt;[l1a2],[l1a2],[l1a1]) AS l1a<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[ex2]-[ex1] AS l1b1<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[age]-[ex1] AS l1b2<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">IIf([l1b1]&gt;[l1b2],[l1b2],[l1b1]) AS l1b<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[age]-[ex2] AS l1c<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[ex1]-[age] AS l2a<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[ex2]-[ex1] AS l2b1<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[ex2]-[age] AS l2b2<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">IIf([l2b1]&gt;[l2b2],[l2b2],[l2b1]) AS l2b<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[end]-[ex2] AS l2c1<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[end]-[age] AS l2c2<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">IIf([l2c1]&gt;[l2c2],[l2c2],[l2c1]) AS l2c<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.eventday INTO [0010 SCCS_preprocess]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0020 Event q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0020 Event]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">(([eventday]&lt;[ex1]) And ([eventday]&lt;[age])) AS El1a<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">([ex1]&lt;[eventday]+1) And ([eventday]&lt;[ex2]+1) And ([eventday]&lt;[age]) AS El1b<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">([ex2]&lt;[eventday]) And ([eventday]&lt;[age]) AS El1c<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">([age]&lt;[eventday]+1) And ([eventday]&lt;[ex1]) AS El2a<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">([age]&lt;[eventday]+1) And ([ex1]&lt;[eventday]+1) And ([eventday]&lt;[ex2]+1) AS El2b<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">([age]&lt;[eventday]+1) And ([ex2]&lt;[eventday]) AS El2c INTO [0020 Event]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0030 L1A q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0030 L1A]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Abs([El1a]) AS event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess].l1a AS [interval]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">1 AS agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">0 AS exgr INTO [0030 L1A]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">(Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0010 SCCS_preprocess].indiv) INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0020 Event] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0020 Event].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0040 L1B q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0040 L1B]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Abs([El1b]) AS event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess].l1b AS [interval]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">1 AS agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">1 AS exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[ex2]&gt;[Oxford]![start] AS term1<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[Oxford]![end]&gt;[ex1] AS rerm2 INTO [0040 L1B]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">(Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0010 SCCS_preprocess].indiv) INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0020 Event] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0020 Event].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">((([0010 SCCS_preprocess].l1b)&gt;0) And<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">(([ex2]&gt;[Oxford]![start])=True) And<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">(([Oxford]![end]&gt;[ex1])=True))<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0050 L1C q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0050 L1C]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Abs([El1c]) AS event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess].l1c AS [interval]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">1 AS agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">0 AS exgr INTO [0050 L1C]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">(Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0010 SCCS_preprocess].indiv) INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0020 Event] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0020 Event].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">((([0010 SCCS_preprocess].l1c)&gt;0))<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0060 L2A q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0060 L2A]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Abs([El2a]) AS event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess].l2a AS [interval]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">2 AS agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">0 AS exgr INTO [0060 L2A]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">(Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0010 SCCS_preprocess].indiv) INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0020 Event] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0020 Event].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">((([0010 SCCS_preprocess].l2a)&gt;0))<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0070 L2B q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0070 L2B]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Abs([El2b]) AS event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess].l2b AS [interval]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">2 AS agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">1 AS exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[ex2]&gt;[Oxford]![start] AS term1<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[Oxford]![end]&gt;[ex1] AS rerm2 INTO [0070 L2B]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">(Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0010 SCCS_preprocess].indiv) INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0020 Event] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0020 Event].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">((([0010 SCCS_preprocess].l2b)&gt;0) And<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">(([ex2]&gt;Oxford!start)=True) And<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">((Oxford!end&gt;[ex1])=True))<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0080 L2C q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0080 L2C]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Abs([El2c]) AS event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess].l2c AS [interval]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">2 AS agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">0 AS exgr INTO [0080 L2C]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">(Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0010 SCCS_preprocess] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0010 SCCS_preprocess].indiv) INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0020 Event] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0020 Event].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">where<\/td>\n<td colspan=\"2\" width=\"948\">((([0010 SCCS_preprocess].l2c)&gt;0))<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0090 chopdat1A q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0030 L1A].event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0030 L1A].interval<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0030 L1A].agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0030 L1A].exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Log([interval]) AS loginterval INTO [0090 chopdat]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0030 L1A] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0030 L1A].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0100 chopdat1B q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">insert<\/td>\n<td width=\"330\">[0090 chopdat]<\/td>\n<td width=\"618\">Oxford.indiv = [0040 L1B].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">indiv<\/td>\n<td width=\"618\">\u2190 Oxford.[indiv]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">event<\/td>\n<td width=\"618\">\u2190 [0040 L1B].event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">[interval]<\/td>\n<td width=\"618\">\u2190 [0040 L1B].interval<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">agegr<\/td>\n<td width=\"618\">\u2190 [0040 L1B].agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">exgr<\/td>\n<td width=\"618\">\u2190 [0040 L1B].exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">loginterval<\/td>\n<td width=\"618\">\u2190 Log([interval]) AS loginterfal<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0040 L1B] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0040 L1B].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0110 chopdat1C q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">insert<\/td>\n<td width=\"330\">[0090 chopdat]<\/td>\n<td width=\"618\">Oxford.indiv = [0050 L1C].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">indiv<\/td>\n<td width=\"618\">\u2190 Oxford.[indiv]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">event<\/td>\n<td width=\"618\">\u2190 [0050 L1C].event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">[interval]<\/td>\n<td width=\"618\">\u2190 [0050 L1C].interval<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">agegr<\/td>\n<td width=\"618\">\u2190 [0050 L1C].agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">exgr<\/td>\n<td width=\"618\">\u2190 [0050 L1C].exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">loginterval<\/td>\n<td width=\"618\">\u2190 Log([interval]) AS loginterfal<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0050 L1C] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0050 L1C].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0120 chopdat2A q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">insert<\/td>\n<td width=\"330\">[0090 chopdat]<\/td>\n<td width=\"618\">Oxford.indiv = [0060 L2A].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">indiv<\/td>\n<td width=\"618\">\u2190 Oxford.[indiv]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">event<\/td>\n<td width=\"618\">\u2190 [0060 L2A].event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">[interval]<\/td>\n<td width=\"618\">\u2190 [0060 L2A].interval<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">agegr<\/td>\n<td width=\"618\">\u2190 [0060 L2A].agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">exgr<\/td>\n<td width=\"618\">\u2190 [0060 L2A].exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">loginterval<\/td>\n<td width=\"618\">\u2190 Log([interval]) AS loginterfal<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0060 L2A] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0060 L2A].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0130 chopdat2B q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">insert<\/td>\n<td width=\"330\">[0090 chopdat]<\/td>\n<td width=\"618\">Oxford.indiv = [0070 L2B].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">indiv<\/td>\n<td width=\"618\">\u2190 Oxford.[indiv]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">event<\/td>\n<td width=\"618\">\u2190 [0070 L2B].event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">[interval]<\/td>\n<td width=\"618\">\u2190 [0070 L2B].interval<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">agegr<\/td>\n<td width=\"618\">\u2190 [0070 L2B].agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">exgr<\/td>\n<td width=\"618\">\u2190 [0070 L2B].exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">loginterval<\/td>\n<td width=\"618\">\u2190 Log([interval]) AS loginterfal<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0070 L2B] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0070 L2B].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0140 chopdat L2C q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">insert<\/td>\n<td width=\"330\">[0090 chopdat]<\/td>\n<td width=\"618\">Oxford.indiv = [0080 L2C].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">indiv<\/td>\n<td width=\"618\">\u2190 Oxford.[indiv]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">event<\/td>\n<td width=\"618\">\u2190 [0080 L2C].event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">[interval]<\/td>\n<td width=\"618\">\u2190 [0080 L2C].interval<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">agegr<\/td>\n<td width=\"618\">\u2190 [0080 L2C].agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">exgr<\/td>\n<td width=\"618\">\u2190 [0080 L2C].exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">field<\/td>\n<td width=\"330\">loginterval<\/td>\n<td width=\"618\">\u2190 Log([interval]) AS loginterfal<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford INNER JOIN<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0080 L2C] ON<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">Oxford.indiv = [0080 L2C].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u30af\u30a8\u30ea\u540d<\/td>\n<td colspan=\"2\" width=\"948\">0150 chopdat q<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">\u8aac\u3000\u660e<\/td>\n<td colspan=\"2\" width=\"948\"><\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select_into<\/td>\n<td colspan=\"2\" width=\"948\">[0150 chopdat]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat].indiv<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat].event<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat].interval<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat].agegr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat].exgr<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">select<\/td>\n<td colspan=\"2\" width=\"948\">Round([0090 chopdat]![loginterval],6) AS loginterval INTO [0150 chopdat]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">from<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat]<\/td>\n<\/tr>\n<tr>\n<td width=\"78\">order by<\/td>\n<td colspan=\"2\" width=\"948\">[0090 chopdat].indiv<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>\u5148\u65e5\u306e\u89e3\u6790\u3067\u4f7f\u7528\u3057\u305fSQL \u30b9\u30af\u30ea\u30d7\u30c8\u3067\u3059 \u30b3\u30de\u30f3\u30c9 \u30d5\u30a3\u30fc\u30eb\u30c9\u540d \u8ffd\u52a0\u5143\u30fb\u66f4\u65b0\u5143 \u30af\u30a8\u30ea\u540d 0010 SCCS_preprocess q \u8aac\u3000\u660e select_into [0010 SCCS_preprocess] s&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-323","post","type-post","status-publish","format-standard","hentry","category-miscellaneous"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9b6zl-5d","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/posts\/323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=323"}],"version-history":[{"count":0,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=\/wp\/v2\/posts\/323\/revisions"}],"wp:attachment":[{"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/plaza.umin.ac.jp\/~OIO\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}