Date: Tue, 14 Aug 2001 18:21:50 -0400
Reply-To: rpresley <rpresley@GMCF.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: rpresley <rpresley@GMCF.ORG>
Subject: macro variable as list for IN operator
Content-Type: text/plain; charset="iso-8859-1"
SAS-Lers,
I have formed a list of CPT codes into a macro variable. I want to use this
macro variable in the IN operator in PROC SQL. Please advise me regarding
the error.
Thanks.
18 rsubmit;
NOTE: Remote submit to MICKEY commencing.
SYMBOLGEN: Macro variable INVAR resolves to '97032', '97033', '97034',
'97035', '97036',
'97110', '97112', '97113', '97116', '97124', '97139', '97140',
'97504', '97520',
'97530', '97535', '97537', '97542', '97703', '97750', '97770' ,
'90804', '90805',
'90810', '90811', '90816', '90817', '90823', '90824', '90875',
'99292', '99374',
'99377', '99379' , '90806', '90807', '90812', '90813', '90818',
'90819', '90826',
'90827', '90876', '95117', '95812', '95920', '95961', '95972',
'95973', '95974',
'95975', '96100', '96105', '96111', '96115', '96410', '99291',
'99354', '99355',
'99356', '99357', '99358', '99375', '99377', '99378', '99380' ,
'90808', '90809',
'90814', '90815', '90821', '90822', '90828', '90829', '95813',
'95962', '96410',
'96414', '96423', '97545', '97546' , '99221', '99222', '99223',
'99295', '99296',
'99297', '99298'
SYMBOLGEN: Some characters in the above value which were subject to macro
quoting have been
unquoted for printing.
236 %put the value of INVAR is &invar. ;
the value of INVAR is '97032', '97033', '97034', '97035', '97036', '97110',
'97112', '97113',
'97116', '97124', '97139', '97140', '97504', '97520', '97530', '97535',
'97537', '97542',
'97703', '97750', '97770' , '90804', '90805', '90810', '90811', '90816',
'90817', '90823',
'90824', '90875', '99292', '99374', '99377', '99379' , '90806', '90807',
'90812', '90813',
'90818', '90819', '90826', '90827', '90876', '95117', '95812', '95920',
'95961', '95972',
'95973', '95974', '95975', '96100', '96105', '96111', '96115', '96410',
'99291', '99354',
'99355', '99356', '99357', '99358', '99375', '99377', '99378', '99380' ,
'90808', '90809',
'90814', '90815', '90821', '90822', '90828', '90829', '95813', '95962',
'96410', '96414',
'96423', '97545', '97546' , '99221', '99222', '99223', '99295', '99296',
'99297', '99298'
237 proc sql;
238 create table time_limit_procs as
239 select rec_id, proc_cd, units, amt_pd
240 from mdclaims.claims_details
241 where rec_id >=990000000000
242 and proc_cd in (&invar)
SYMBOLGEN: Macro variable INVAR resolves to '97032', '97033', '97034',
'97035', '97036',
'97110', '97112', '97113', '97116', '97124', '97139', '97140',
'97504', '97520',
'97530', '97535', '97537', '97542', '97703', '97750', '97770' ,
'90804', '90805',
'90810', '90811', '90816', '90817', '90823', '90824', '90875',
'99292', '99374',
'99377', '99379' , '90806', '90807', '90812', '90813', '90818',
'90819', '90826',
'90827', '90876', '95117', '95812', '95920', '95961', '95972',
'95973', '95974',
'95975', '96100', '96105', '96111', '96115', '96410', '99291',
'99354', '99355',
'99356', '99357', '99358', '99375', '99377', '99378', '99380' ,
'90808', '90809',
'90814', '90815', '90821', '90822', '90828', '90829', '95813',
'95962', '96410',
'96414', '96423', '97545', '97546' , '99221', '99222', '99223',
'99295', '99296',
'99297', '99298'
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 "INVAR".
242 '97032', '97033', '97034', '97035', '97036', '97110', '97112', '97113',
'97116', '97124',
-
22
-
76
242! '97139', '97140', '97504', '97520', '97530', '97535', '97537', '97542',
'97703', '97750',
242! '97770' , '90804', '90805', '90810', '90811', '90816', '90817',
'90823',
ERROR 22-322: Syntax error, expecting one of the following: a quoted string,
a numeric constant, a datetime constant, a missing value, (,
-, SELECT.
ERROR 76-322: Syntax error, statement will be ignored.
243 ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of
statements.
244 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used:
real time 0.00 seconds
cpu time 0.01 seconds
NOTE: Remote submit to MICKEY complete.
Rodney J. Presley, PhD
Georgia Medical Care Foundation
57 Executive Park South, NE
suite 200
Atlanta, GA 30329-2224
404-982-0411 ext. 7574
404-982-7592 fax
rpresley@gmcf.org
------------------------
CONFIDENTIALITY NOTICE: This e-mail transmission, and any documents, files
or previous e-mail messages attached to it may contain proprietary,
privileged or confidential information. If you are not an intended
recipient, or a person responsible for delivering it to the intended
recipient, you are hereby notified that any disclosure, copying,
distribution or use of any of the information contained in or
attached to this transmission is STRICTLY PROHIBITED. If you have
received this transmission in error, please immediately notify me by
reply e-mail and destroy the original transmission and its
attachments without saving them in any manner.
-----------------------
| 
