Hi, I'm using a case else statement to try to create a new variable (source_flag) to fill in for blank for the first_source variable, however it is not populating the new variable definition of 'unknown' when it runs.  Any help would be greately appreciated.   proc sql; create table d02_buyer_source_recency as select DISTINCT email_id, /* first source */ first_source, first_available_source, CASE when (first_source = ' ' OR first_source = '.') then 'UNKNOWN' ELSE first_source END as Source_Flag from oralib.sum_email_list_vw ; quit; ... View more