Hi I am relatively new to the world of SQL and am now using SAS Studio as part of my role, so please forgive me if this is an obvious question. I am trying to write a SQl statement that will tell me how many values in one list don't match those in another list, in this instance Cost Centres, but when i run the report it returns hundreds of thousands of rows rather than an expected 30 or 40. Can anyone signpost me as to where I am going wrong? proc sql; create table DQ As select case when r.CostCentre ^= d.CostCentredq then 1 else 0 end as WrongCostCentre from data.resources r, valibla.dq_res d; quit; Thanks in advance for any help
... View more