用於指定DBQ的腳本<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />嗨，
我想知道如何指定數據庫的來源，所以這可能作為一個全局聲明，可以由每個dt =引用。正如您在下面的腳本中看到的，為了從多個Access表中獲取數據，我複制了DBQ = .... 對於每個dt =。唯一的區別是“SELECT ...”部分。在SAS中，我會寫一個宏變量（％let dir = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis \）來指定數據庫的位置。但我還沒有學會如何在JMP中做類似的事情。我已經強調了前兩個dt =的重複部分。我的腳本已附上。
DT1 = 打開數據庫（“DBQ = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis \ Chang_bee_db.mdb; DefaultDir = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis; Driver = {Microsoft Access Driver（* .mdb）} ; DriverId = 25; FIL = MS Access; FILEDSN = C：\ Program Files \ Common Files \ ODBC \ Data Sources \ chang_bee_db.dsn ; MAXBUFFERSIZE = 2048;的MaxScanRows = 8;將PageTimeout = 5; SafeTransactions = 0;線程= 3; UID =管理員; UserCommitSync =是;“，
“SELECT * FROM qryAFF14”，“qryAFF14”，隱形）;
DT2 = 打開數據庫（“DBQ = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis \ Chang_bee_db.mdb; DefaultDir = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis; Driver = {Microsoft Access Driver（* .mdb）} ; DriverId = 25; FIL = MS Access; FILEDSN = C：\ Program Files \ Common Files \ ODBC \ Data Sources \ chang_bee_db.dsn ; MAXBUFFERSIZE = 2048;的MaxScanRows = 8;將PageTimeout = 5; SafeTransactions = 0;線程= 3; UID =管理員; UserCommitSync =是;“，
“SELECT * FROM qryALF0”，“qryALF0”，隱形）;
dt3 =打開數據庫（“DBQ = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis \ Chang_bee_db.mdb; DefaultDir = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis; Driver = {Microsoft Access Driver（* .mdb ）}; DriverId = 25; FIL = MS Access; FILEDSN = C：\ Program Files \ Common Files \ ODBC \ Data Sources \ chang_bee_db.dsn; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID =管理員; UserCommitSync =是;“，
“SELECT treatment，bee，age，days_exp_cum，trips_exp_count FROM qryTrips_days_exp”，“qryTrips_days_exp”，隱身）;
dt4 =打開數據庫（“DBQ = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis \ Chang_bee_db.mdb; DefaultDir = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis; Driver = {Microsoft Access Driver（* .mdb ）}; DriverId = 25; FIL = MS Access; FILEDSN = C：\ Program Files \ Common Files \ ODBC \ Data Sources \ chang_bee_db.dsn; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID =管理員; UserCommitSync =是;“，
“SELECT * FROM qryLeft_time_hour”，“qryLeft_time_hour”，隱形）;
dt5 =打開數據庫（“DBQ = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis \ Chang_bee_db.mdb; DefaultDir = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis; Driver = {Microsoft Access Driver（* .mdb ）}; DriverId = 25; FIL = MS Access; FILEDSN = C：\ Program Files \ Common Files \ ODBC \ Data Sources \ chang_bee_db.dsn; MaxBufferSize = 2048; MaxScanRows = 8; PageTimeout = 5; SafeTransactions = 0; Threads = 3; UID =管理員; UserCommitSync =是;“，
“SELECT * FROM qryCombo_exp”，“qryCombo_exp”，不可見）;
Re：用於指定DBQ的腳本試試這個：
dbq_string = “DBQ = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben analysis \ Chang_bee_db.mdb;” ||
“DefaultDir = E：\ Now \（Project）RFID_r3_Homing_r1 \ Ben分析;” ||
“Driver = {Microsoft Access Driver（* .mdb）}; DriverId = 25; FIL = MS Access;” ||
“FILEDSN = C：\ Program Files \ Common Files \ ODBC \ Data Sources \ chang_bee_db.dsn;” ||
“MAXBUFFERSIZE = 2048;的MaxScanRows = 8;將PageTimeout = 5; SafeTransactions = 0;線程= 3; UID =管理員; UserCommitSync =是;” ;
DT1 = 打開數據庫 （ dbq_string ，
“SELECT * FROM qryAFF14” ， “qryAFF14” ，無形 ） ;
DT2 = 打開數據庫 （ dbq_string ，
“SELECT * FROM qryALF0” ， “qryALF0” ，無形 ） ;
DT3 = 打開數據庫 （ dbq_string ，
“SELECT處理，蜜蜂，年齡，days_exp_cum，trips_exp_count FROM qryTrips_days_exp” ， “qryTrips_days_exp” ，無形 ） ;
DT4 = 打開數據庫 （ dbq_string ，
“SELECT * FROM qryLeft_time_hour” ， “qryLeft_time_hour” ，無形 ） ;
DT5 = 打開數據庫 （ dbq_string ，
“SELECT * FROM qryCombo_exp” ， “qryCombo_exp” ，無形 ） ;
