Executed the below SAS script with case statement to populate the value of subscriber_type as 'Primary' if the date fields CFR_CREATE_DATE = BAN_START_DATE and if the difference between CFR_CREATE_DATE minus BAN_START_DATE <= 30 days then the value of subscriber_type will be 'AAL <= 30' and if the difference between CFR_CREATE_DATE minus BAN_START_DATE > 30 then 'AAL > 30' else Null. How can this be done in PROC SQL? Note: CFR_CREATE_DATE & BAN_START_DATE used in the below script are both date data type fields SAS SCRIPT: proc sql; connect to oracle(&xyz); create table CANCELS_SUB as Select CASE WHEN TRUNC(b.CFR_CREATE_DATE) = TRUNC(b.BAN_START_DATE) THEN 'PRIMARY' WHEN TRUNC(b.CFR_CREATE_DATE) <> TRUNC(b.BAN_START_DATE) AND (TRUNC(b.CFR_CREATE_DATE) - TRUNC(b.BAN_START_DATE)) <= 30 THEN 'AAL <= 30' WHEN TRUNC(b.CFR_CREATE_DATE) <> TRUNC(b.BAN_START_DATE) AND (TRUNC(b.CFR_CREATE_DATE) - TRUNC(b.BAN_START_DATE)) > 30 THEN 'AAL > 30' ELSE NULL END as SUBSCRIBER_TYPE from WORK.'COPY OF TRANSACTIONAL SURVEY DAT'n a left join xys.DAILY_CONSUMER_POST_CANCELS b ON a.BAN = b.BAN ; Error Log: NOTE: The "<>" operator is interpreted as "not equals". ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Expression using subtraction (-) requires numeric types. 2 The SAS System 11:31 Wednesday, July 21, 2021 ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Function TRUNC requires at least 2 argument(s). ERROR: Expression using subtraction (-) requires numeric types. ERROR: The following columns were not found in the contributing tables: NULL.
... View more