I'm trying to recode RuleFlag to the value of '1' (&Rule_Order_Char) when the following conditions are met:     A.ACTUAL_DLVRY_DATE IS NULL AND B.ACTUAL_DLVRY_DATE IS NOT NULL or A.ACTUAL_DLVRY_DATE > B.ACTUAL_DLVRY_DATE AND a.RULEFLAG = "-"   But I'm getting the error:     ERROR: Operand of WHEN clause 1 is not the same data type as the CASE operand.   Am I using Case the wrong way? Is there another way to achieve the desired recoding during a Select statement? ny help would be much appreciated.   2224 proc sql; 2225 create table QueryData&ZIP5._&RULE_ORDER_CHAR as SYMBOLGEN: Macro variable ZIP5 resolves to 00926 SYMBOLGEN: Macro variable RULE_ORDER_CHAR resolves to 1 2226 select DISTINCT %unquote(%str(%')&ANALYSIS_DESC.%str(%')) as rule_nm length = 58, SYMBOLGEN: Macro variable ANALYSIS_DESC resolves to TEST 2227 a.actual_dlvry_date as ad_dt, 2228 a.imb_code length = 31, 2229 &RULE_ORDER as rule_order, SYMBOLGEN: Macro variable RULE_ORDER resolves to 1 2230 a.imb_dlvry_zip_5, 2231 CASE a.RULEFLAG 2232 WHEN A.ACTUAL_DLVRY_DATE IS NULL AND B.ACTUAL_DLVRY_DATE IS NOT NULL or A.ACTUAL_DLVRY_DATE > B.ACTUAL_DLVRY_DATE AND a.RULEFLAG = "-" THEN "&RULE_ORDER_CHAR" SYMBOLGEN: Macro variable RULE_ORDER_CHAR resolves to 1 2233 END as rule_flag 2234 from QueryData&ZIP5 as a SYMBOLGEN: Macro variable ZIP5 resolves to 00926 2235 inner join QueryData&ZIP5 as b SYMBOLGEN: Macro variable ZIP5 resolves to 00926 2236 on a.imb_code=b.imb_code 2237 where a.source="A" and b.source="B"; ERROR: Operand of WHEN clause 1 is not the same data type as the CASE operand. NOTE: A CASE expression has no ELSE clause. Cases not accounted for by the WHEN clauses will result in a missing value for the CASE expression. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 2238 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):   ... View more

I need some help troubleshooting this error. Am I doing something wrong here?   4621 proc sql; 4622 create table QueryData&ZIP5 as SYMBOLGEN: Macro variable ZIP5 resolves to 00926 4623 select *, 4624 "A" as source, 4625 "-" as RuleFlag, 4626 "-" as rule_nm length = 58, 4627 a.actual_dlvry_date as ad_dt, 4628 a.imb_code length = 31, 4629 "-" as rule_order, 4630 a.imb_dlvry_zip_5 4631 from ods_iv_recon_selected_mp as a 4632 where imb_dlvry_zip_5=&ZIP5_QUOTED SYMBOLGEN: Macro variable ZIP5_QUOTED resolves to '00926' 4633 union all corresponding 4634 select *, 4635 "B" as source, 4636 "-" as RuleFlag, 4637 "-" as rule_nm length = 58, 4638 b.actual_dlvry_date as ad_dt, 4639 b.imb_code length = 31, 4640 "-" as rule_order, 4641 b.imb_dlvry_zip_5 4642 from ods_bi_recon_selected_mp as b 4643 where imb_dlvry_zip_5=&ZIP5_QUOTED; SYMBOLGEN: Macro variable ZIP5_QUOTED resolves to '00926' ERROR: Duplicate column names have been detected in the above query which requested that CORRESPONDING column names be matched. This situation is ambiguous. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 4644 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

Hi. I have two datasets...FinalData01234 and FinalData02360 that I want to Proc Append together into a ds named FinalData.  Each of these datasets have Proc Transposed data where date values have become column names (e.g. _05_08_2016). I have no trouble appending FinalData01234 to FinalData because FinalData doesn't exist yet so it creates it using the data in the ds FinalData01234.   However, when I append the second ZIP Code specific ds named FinalData02360 it has column names that didn't exist in FinalData01234 (e.g. _05_09_2016). When this happens I get errors of the type below. How can I get these new column names to append without erroring?   Any help would be greatly appreciated.   NOTE: Appending WORK.FINALDATA02360 to WORK.FINALDATA. WARNING: Variable _05_09_2016 was not found on BASE file. The variable will not be added to the BASE file. WARNING: Variable _03_25_2016 was not found on BASE file. The variable will not be added to the BASE file. WARNING: Variable _01_06_2016 was not found on BASE file. The variable will not be added to the BASE file. WARNING: Variable _12_08_2015 was not found on BASE file. The variable will not be added to the BASE file. WARNING: Variable _12_03_2015 was not found on BASE file. The variable will not be added to the BASE file. WARNING: Variable _11_27_2015 was not found on BASE file. The variable will not be added to the BASE file.   ... View more