Date:         Wed, 23 Jul 2003 10:09:12 +0300
Reply-To:     MLiberts@csb.gov.lv
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         MLiberts@csb.gov.lv
Subject:      Path defined by macro
Content-type: text/plain; charset=us-ascii

Hi listers,

I have defined the path to files with macro:

define !cels() "C:\My Documents\Darbs\Imputation\new\2-darbs\Exports"
!enddefine.

I want to use this macro in Get Capture ODBC query:

GET CAPTURE ODBC
 /CONNECT=
  "DSN=MS Access Database;"+
  "DBQ="+!cels+"\2002C4\2-darbs_02C4.mdb;"+
  "DefaultDir="+!cels+"\2002C4;"+
  "DriverId=25;"+
  "FIL=MS Access;"+
  "MaxBufferSize=2048;"+
  "PageTimeout=5;"
 /SELECT
  "T3"."uuk"AS "uuk",
  "T3"."rnr"AS "rnr",
  "T3"."cnr"AS "cnr",
  "T3"."code"AS "code",
  "T3"."mark"AS "mark",
  "T3"."cvalue"AS "cvalue"
   FROM !cels+"\2002C4\2-darbs_02C4"."values" "T3".

But this query is not working. Actualy the problem is in FROM statement. If
I put real path in FROM statement, it works:

GET CAPTURE ODBC
 /CONNECT=
  "DSN=MS Access Database;"+
  "DBQ="+!cels+"\2002C4\2-darbs_02C4.mdb;"+
  "DefaultDir="+!cels+"\2002C4;"+
  "DriverId=25;"+
  "FIL=MS Access;"+
  "MaxBufferSize=2048;"+
  "PageTimeout=5;"
 /SELECT
  "T3"."uuk"AS "uuk",
  "T3"."rnr"AS "rnr",
  "T3"."cnr"AS "cnr",
  "T3"."code"AS "code",
  "T3"."mark"AS "mark",
  "T3"."cvalue"AS "cvalue"
   FROM "C:\My Documents\Darbs\Imputation\new\2-darbs\Exports"+"
\2002C4\2-darbs_02C4"."values" "T3".

Any ideas how to make the macro to work in this query?

--
Martins Liberts
Central Statistical Bureau of Latvia
address: Lacplesa iela 1, Riga, LV-1301, Latvia
phone: 371-7366877
email: mliberts@csb.gov.lv