I am running following code and getting error. I am assuming i need to change code value from single quote to double quote but not sure how and where. Please help. data temp1; set dst_codes; by account; format serv $300.; retain serv; if first.account then serv = "'"||code||"'" ; else do; serv = compress(serv||",'"||code||"'", ' '); end; if last.account then output; drop code; run; NOTE: There were 13 observations read from the data set WORK.DST_CODES. NOTE: The data set WORK.TEMP1 has 1 observations and 2 variables. NOTE: Compressing data set WORK.TEMP1 increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds proc sql; select serv into :service1 from temp1; quit; NOTE: The PROCEDURE SQL printed page 2. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds libname idst oracle user=BA01NPTNE password=XXXXXXXXX path=iddp2 schema=ggs readbuff = 250000; NOTE: Libref IDST was successfully assigned as follows: Engine: ORACLE Physical Name: iddp2 proc sql; create table sasds.intl_dst_&day as select compress(put(a.acctcorp,z5.)||'/'||put(a.house,6.)||'/'||put(a.cust,2.), ' ') as acctnum, serv as bill_code, put(a.acctcorp,Z5.)as acctcorp from idst.idst_cust_rate as a, idst.idst_customer as b where a.acctcorp = b.acctcorp and a.house = b.house and a.cust = b.cust and b.stat in ('3','4','5') and serv in ( &service1) NOTE: Line generated by the macro variable "SERVICE1". 10 The SAS System 05:00 Thursday, April 12, 2012 190 '*V','*X','*Y','>G','B:','E$','E+','.(','.)','.+','_8','!'7','!'8' ___ 49 _ 22 76 NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ), ','. ERROR 76-322: Syntax error, statement will be ignored. 191 and put(a.acctcorp,z5.) ne '05645'; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds
... View more