Thanks Markus for the lead ... View more

Thank you Tom- This worked like a charm ... View more

157 proc sql; 1158 create table c as 1159 select coalesce(a.id, b.id) as id format = 10, gl1, gl2 -- 22 76 ERROR 22-322: Expecting a format name. ERROR 76-322: Syntax error, statement will be ignored. 1160 from a full join b 1161 on a.ID = b.ID; 1162 quit; ... View more

Mike using this , I still get this error- see attached. ... View more

Thank you for your prompt response, I have never used this coalese function and I get this error. can you assist? 1039 proc sql; 1040 create table c as 1041 1042 select coalesce(a.id, b.id) gl1 gl2 --- 22 202 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=. ERROR 202-322: The option or parameter is not recognized and will be ignored. 1043 from a full join b 1044 on a.ID = b.ID; 1045 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds   ... View more