悬赏 5 个论坛币 未解决
各位大大,
在用SPSS提取Taredata数据库里的数据的时候碰到这样一个问题:
我想提取2011-08-17到2011-08-18这两天的数据,应该怎样写GET DATA中的SQL语句?
以下是code,红色标记处报错。
Code:
GET DATA
/TYPE=ODBC
/CONNECT='DSN=WMM;UID=d1song;PWD=#".,#Q!U3N1m*S+c; '
/SQL='SELECT T0.CREATE_DATE, T0.ITEM_NBR, T0.OLD_NBR, T0.PRIMARY_DESC, T0.SECONDARY_DESC, '+
'T0.SIZE_DESC, T0.UPC, T0.UPC_DESC, T0.ACCT_DEPT_NBR, T0.FINELINE, T1.FINELINE_DESC, '+
'T2.ORDER_DEPT_NBR, T2.DEPT_DESC, T2.ACCT_DEPT_NBR, SUBSTRING(T1.FINELINE,1,2) AS CATEGORY_NBR, convert(t0.create_date,'')FROM '+
'CN_WM_VM.ITEM_DESC_ASCII T0, CN_WM_VM.SUBCLASS_FINELINE_DESC T1, CN_WM_VM.DEPT_DESC T2 WHERE '+
't0.acct_dept_nbr in (1,2,4,6,8,10,13,14,15,17,22,25,26,40,46,82,89,90,91,92,93,95,96,74,94)'+
'and t0.create_data between '2011-08-17' and '2011-08-18''+
'and T0.ACCT_DEPT_NBR = T2.ACCT_DEPT_NBR and T2.ORDER_DEPT_NBR = T1.ORDER_DEPT_NBR AND T0.FINELINE '+
'= T1.FINELINE'
/ASSUMEDSTRWIDTH=255.
CACHE.
EXECUTE.
ALTER TYPE ALL(A=AMIN).
DATASET NAME DataSet1 WINDOW=FRONT.