Hi Can someone please help me. I am trying to run the following query: Proc SQL; Create table Temp as Select * from MM.mom_Claims Where CLAIM_NO in (Select input(CLAIM_NO,15.) from PMB_ICD_Codes); Quit; However I am getting the following error: 8157 Proc SQL; 8158 Create table Temp as 8159 Select * 8160 from MM.mom_Claims 8161 Where CLAIM_NO in (Select input(CLAIM_NO,15.) from PMB_ICD_Codes); ERROR: INPUT function requires a character argument. ERROR: INPUT function requires a character argument. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. 8162 8163 Quit; Note: In both the PMB_ICD_Code and mom_Claims file the CLAIM_NO field has the following attributes: Lenght: 8 Format: 10. Informat: 10. Type: Numeric I am not sure how to rewrite this as a I am very new to SAS. Thanks in advance
... View more