用于指定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” ，无形 ） ;
