Date: Tue, 8 May 2001 13:23:17 -0400
Reply-To: Charles Brokmann <cab@AIMSCO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Charles Brokmann <cab@AIMSCO.COM>
Subject: Proc SQL & datetimes(us5496238)
Content-Type: multipart/mixed;
I was wondering if anyone had any ideas about this?
Win2000pro, SASV8.2
I have run this query through "QueryAnalyzer" and it works fine,
and I have tried formatting the value of "sas_date_from/to" a number of
ways, but still to no avail.
Any assistance would be appreciated.
Thanks,
Charles
> -----Original Message-----
> From: Charles Brokmann
> Sent: Tuesday, May 08, 2001 12:56 PM
> To: 'support@sas.com'
> Subject: us5496238
>
> Here is the log output:
>
> 272 options sastrace=',,,d' sastraceloc=SASLOG nostsuffix mprint
> symbolgen;
> 273 %macro hist_devl;
> 274
> 275 libname wqcadata odbc dsn=web_qca uid=web_qca_admin
> pwd=web_qca_admin;
> 276
> 277 %let date_time_from = %cmpres(%str(01MAR2001:00:00:00.000));
> 278 %let date_time_to = %cmpres(%str(01APR2001:00:00:00.000));
> 279 %put date_time_from -> date_time_to = [&date_time_from ->
> &date_time_to];
>
> 280 %let day = %substr(&date_time_from,1,2);
> 281 %put day = [&day];
> 282 %let month = %substr(&date_time_from,3,3);
> 283 %if &month = %str(JAN) %then %let month=%str(01);
> 284 %if &month = %str(FEB) %then %let month=%str(02);
> 285 %if &month = %str(MAR) %then %let month=%str(03);
> 286 %if &month = %str(APR) %then %let month=%str(04);
> 287 %if &month = %str(MAY) %then %let month=%str(05);
> 288 %if &month = %str(JUN) %then %let month=%str(06);
> 289 %if &month = %str(JUL) %then %let month=%str(07);
> 290 %if &month = %str(AUG) %then %let month=%str(08);
> 291 %if &month = %str(SEP) %then %let month=%str(09);
> 292 %if &month = %str(OCT) %then %let month=%str(10);
> 293 %if &month = %str(NOV) %then %let month=%str(11);
> 294 %if &month = %str(DEC) %then %let month=%str(12);
> 295 %put month = [&month];
> 296 %let year = %substr(&date_time_from,6,4);
> 297 %put year = [&year];
> 298 %let hour = %substr(&date_time_from,11,2);
> 299 %put hour = [&hour];
> 300 %let minute = %substr(&date_time_from,14,2);
> 301 %put minute = [&minute];
> 302 %let second = %substr(&date_time_from,17,6);
> 303 %put second = [&second];
> 304 %let date_time_from = &month%str(/)&day%str(/)&year
> &hour%str(:)&minute%str(:)&second;
>
> 305 %put date_time_from = [&date_time_from];
> 306 %let day = %substr(&date_time_to,1,2);
> 307 %put day = [&day];
> 308 %let month = %substr(&date_time_to,3,3);
> 309 %if &month = %str(JAN) %then %let month=%str(01);
> 310 %if &month = %str(FEB) %then %let month=%str(02);
> 311 %if &month = %str(MAR) %then %let month=%str(03);
> 312 %if &month = %str(APR) %then %let month=%str(04);
> 313 %if &month = %str(MAY) %then %let month=%str(05);
> 314 %if &month = %str(JUN) %then %let month=%str(06);
> 315 %if &month = %str(JUL) %then %let month=%str(07);
> 316 %if &month = %str(AUG) %then %let month=%str(08);
> 317 %if &month = %str(SEP) %then %let month=%str(09);
> 318 %if &month = %str(OCT) %then %let month=%str(10);
> 319 %if &month = %str(NOV) %then %let month=%str(11);
> 320 %if &month = %str(DEC) %then %let month=%str(12);
> 321 %put month = [&month];
> 322 %let year = %substr(&date_time_to,6,4);
> 323 %put year = [&year];
> 324 %let hour = %substr(&date_time_to,11,2);
> 325 %put hour = [&hour];
> 326 %let minute = %substr(&date_time_to,14,2);
> 327 %put minute = [&minute];
> 328 %let second = %substr(&date_time_to,17,6);
> 329 %put second = [&second];
> 330 %let date_time_to = &month%str(/)&day%str(/)&year
> &hour%str(:)&minute%str(:)&second;
>
> 331 %put date_time_to = [&date_time_to];
> 332
> 333 proc sql;
> 334 select count (distinct date_time)
> 335 into :NUMDATES
> 336 from wqcadata.qca_chart_transaction
> 337 where plant in ("CRONOS")
> 338 and sector in ("ETCH")
> 339 and eq_id in ("EK01")
> 340 and part_id in ("LG33861")
> 341 and process_step in ("ELDP1")
> 342 and mtr_step in ("ELK61")
> 343 and traveler in ("TRAV1")
> 344 and mtr_eq_id in ("QZ10")
> 345 and qc_id in ("LINEWIDTH")
> 346 and chart_id = "TREND2"
> 347 and date_time between &date_time_from and &date_time_to
> 348 ;
> 349 quit;
> 350
> 351 %let NUMDATES = %cmpres(&NUMDATES);
> 352 %put NUMDATES = [&NUMDATES];
> 353 %mend hist_devl;
> TRACE: COMMIT performed on connection 0.
> TRACE: Successful disconnection, id 0
> TRACE: Successful CLI free environment from connection 0
> TRACE: Successful connection made, connection id 0
> TRACE: Database/data source: web_qca
> TRACE: USER=web_qca_admin, PASS=XXXXXXX
> TRACE: AUTOCOMMIT is NO for connection 0
> 354 %hist_devl;
> MPRINT(HIST_DEVL): libname wqcadata odbc dsn=web_qca
> uid=web_qca_admin pwd=web_qca_admin;
> NOTE: Libref WQCADATA was successfully assigned as follows:
> Engine: ODBC
> Physical Name: web_qca
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 0
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable VALUE resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable VALUE resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 22
> SYMBOLGEN: Macro variable I resolves to 22
> SYMBOLGEN: Macro variable VALUE resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 22
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TARGET resolves to
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TARGET resolves to
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable TEXT resolves to 01MAR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 0
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable VALUE resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable VALUE resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 22
> SYMBOLGEN: Macro variable I resolves to 22
> SYMBOLGEN: Macro variable VALUE resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 22
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TARGET resolves to
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TARGET resolves to
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable TEXT resolves to 01APR2001:00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to
> 01MAR2001:00:00:00.000
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to
> 01APR2001:00:00:00.000
> date_time_from -> date_time_to = [01MAR2001:00:00:00.000 ->
> 01APR2001:00:00:00.000]
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to
> 01MAR2001:00:00:00.000
> SYMBOLGEN: Macro variable DAY resolves to 01
> day = [01]
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to
> 01MAR2001:00:00:00.000
> SYMBOLGEN: Macro variable MONTH resolves to MAR
> SYMBOLGEN: Macro variable MONTH resolves to MAR
> SYMBOLGEN: Macro variable MONTH resolves to MAR
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> month = [03]
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to
> 01MAR2001:00:00:00.000
> SYMBOLGEN: Macro variable YEAR resolves to 2001
> year = [2001]
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to
> 01MAR2001:00:00:00.000
> SYMBOLGEN: Macro variable HOUR resolves to 00
> hour = [00]
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to
> 01MAR2001:00:00:00.000
> SYMBOLGEN: Macro variable MINUTE resolves to 00
> minute = [00]
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to
> 01MAR2001:00:00:00.000
> SYMBOLGEN: Macro variable SECOND resolves to 00.000
> second = [00.000]
> SYMBOLGEN: Macro variable MONTH resolves to 03
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable DAY resolves to 01
> SYMBOLGEN: Macro variable YEAR resolves to 2001
> SYMBOLGEN: Macro variable HOUR resolves to 00
> SYMBOLGEN: Macro variable MINUTE resolves to 00
> SYMBOLGEN: Macro variable SECOND resolves to 00.000
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to 03/01/2001
> 00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> date_time_from = [03/01/2001 00:00:00.000]
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to
> 01APR2001:00:00:00.000
> SYMBOLGEN: Macro variable DAY resolves to 01
> day = [01]
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to
> 01APR2001:00:00:00.000
> SYMBOLGEN: Macro variable MONTH resolves to APR
> SYMBOLGEN: Macro variable MONTH resolves to APR
> SYMBOLGEN: Macro variable MONTH resolves to APR
> SYMBOLGEN: Macro variable MONTH resolves to APR
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> month = [04]
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to
> 01APR2001:00:00:00.000
> SYMBOLGEN: Macro variable YEAR resolves to 2001
> year = [2001]
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to
> 01APR2001:00:00:00.000
> SYMBOLGEN: Macro variable HOUR resolves to 00
> hour = [00]
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to
> 01APR2001:00:00:00.000
> SYMBOLGEN: Macro variable MINUTE resolves to 00
> minute = [00]
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to
> 01APR2001:00:00:00.000
> SYMBOLGEN: Macro variable SECOND resolves to 00.000
> second = [00.000]
> SYMBOLGEN: Macro variable MONTH resolves to 04
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable DAY resolves to 01
> SYMBOLGEN: Macro variable YEAR resolves to 2001
> SYMBOLGEN: Macro variable HOUR resolves to 00
> SYMBOLGEN: Macro variable MINUTE resolves to 00
> SYMBOLGEN: Macro variable SECOND resolves to 00.000
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to 04/01/2001
> 00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> date_time_to = [04/01/2001 00:00:00.000]
> MPRINT(HIST_DEVL): proc sql;
> SYMBOLGEN: Macro variable DATE_TIME_FROM resolves to 03/01/2001
> 00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> NOTE: Line generated by the macro variable "DATE_TIME_FROM".
> 1 03/01/2001 00:00:00.000
> --
> 22
> SYMBOLGEN: Macro variable DATE_TIME_TO resolves to 04/01/2001
> 00:00:00.000
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> NOTE: Line generated by the macro variable "DATE_TIME_FROM".
> 1 03/01/2001 00:00:00.000
> --
> 76
> ERROR 22-322: Syntax error, expecting one of the following: !!, *, **,
> +, -, /, AND, ||.
>
> ERROR 76-322: Syntax error, statement will be ignored.
>
> MPRINT(HIST_DEVL): select count (distinct date_time) into :NUMDATES
> from
> wqcadata.qca_chart_transaction where plant in ("CRONOS") and sector in
> ("ETCH") and eq_id in
> ("EK01") and part_id in ("LG33861") and process_step in ("ELDP1") and
> mtr_step in ("ELK61") and
> traveler in ("TRAV1") and mtr_eq_id in ("QZ10") and qc_id in
> ("LINEWIDTH") and chart_id =
> "TREND2" and date_time between 03/01/2001 00:00:00.000 and 04/01/2001
> 00:00:00.000 ;
> MPRINT(HIST_DEVL): quit;
> NOTE: The SAS System stopped processing this step because of errors.
> NOTE: PROCEDURE SQL used:
> real time 0.02 seconds
> cpu time 0.02 seconds
>
> WARNING: Apparent symbolic reference NUMDATES not resolved.
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> WARNING: Apparent symbolic reference NUMDATES not resolved.
> SYMBOLGEN: Macro variable I resolves to 0
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> WARNING: Apparent symbolic reference NUMDATES not resolved.
> SYMBOLGEN: Macro variable VALUE resolves to &NUMDATES
> WARNING: Apparent symbolic reference NUMDATES not resolved.
> SYMBOLGEN: Macro variable VALUE resolves to &NUMDATES
> WARNING: Apparent symbolic reference NUMDATES not resolved.
> SYMBOLGEN: Macro variable I resolves to 9
> SYMBOLGEN: Macro variable I resolves to 9
> SYMBOLGEN: Macro variable VALUE resolves to &NUMDATES
> WARNING: Apparent symbolic reference NUMDATES not resolved.
> SYMBOLGEN: Macro variable I resolves to 9
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TARGET resolves to
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TARGET resolves to
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable I resolves to 1
> SYMBOLGEN: Macro variable TEXT resolves to &NUMDATES
> SYMBOLGEN: Some characters in the above value which were subject to
> macro quoting have been
> unquoted for printing.
> SYMBOLGEN: Macro variable I resolves to 1
> WARNING: Apparent symbolic reference NUMDATES not resolved.
> ERROR: The text expression &NUMDATES contains a recursive reference to
> the macro variable
> NUMDATES. The macro variable will be assigned the null value.
> SYMBOLGEN: Macro variable NUMDATES resolves to
> NUMDATES = []
>
> And the dummy macro code with the failing sql query:
> <<hist_devl.sas>>
> Charles
> 919.403.7300 x36
hist_devl.sas [application/octet-stream]
| 
