Hello All, Hope you can help me with below code. I'm using Case When Function in SAS, and I want to combine those two variables to display one output table. My code as below, there's no error when I run the code but the second variable does not produce any data when its run. Is "AND" can be used to combine both variables? SQL; CREATE TABLE WORK.ScribeDeadZone1 AS SELECT t1.SubId, as Location, as ScribeIndex, as Measurement, /* SPULaser */ CASE WHEN EquipmentID = 2825 and 2859 THEN 'KLM11P2' WHEN EquipmentID = 2827 and 2861 THEN 'KLM11P3'
... View more