I cannot run this code for the life of me. I am trying to use some variables to pull data and am coming up short no matter what I try. here is the bit of code PROC SQL; CREATE TABLE WORK.MEMBERSHIP_TABLE AS SELECT t1.UNIQ_ID, t1.Year_Month_Text AS INCURRED_YYYYMM, t2.Group FROM WORK.THISTABLE&Paid_YYYYMM t1 INNER JOIN WORK.THATTABLE_MBRS t2 ON t1.UNIQ_ID = t2.UNIQ_ID WHERE t1.Year_Month_Text BETWEEN &Start_YYYYMM AND &End_YYYYMM; QUIT; Here is the log that keep outputting, you can see my variables are correct and I promise that the columns they are associated with are character columns. 35 PROC SQL; 36 CREATE TABLE WORK.MEMBERSHIP_MDCR AS 37 SELECT t1.UNIQ_ID, 38 t1.Year_Month_Text AS INCURRED_YYYYMM, 39 t2.Group 42 FROM WORK.THISTABLE&Paid_YYYYMM t1 SYMBOLGEN: Macro variable PAID_YYYYMM resolves to 201908 43 INNER JOIN WORK.THATTABLE_MBRS t2 ON t1.UNIQ_ID = t2.UNIQ_ID 2 The SAS System 09:03 Thursday, September 12, 2019 44 WHERE t1.Year_Month_Text BETWEEN &Start_YYYYMM AND &End_YYYYMM; SYMBOLGEN: Macro variable START_YYYYMM resolves to 201901 SYMBOLGEN: Macro variable END_YYYYMM resolves to 201907 ERROR: Expression using IN has components that are of different data types. Aren't variables automatically character variables and not numeric? What do I do to make sure they are character? Thanks
... View more