Hi all   I have some test data below and I would like to have columns with both the Test columns not being null/blank. I have tried below and doesn't seem to be working.   Data have; Name = 'ABC'; Test1 = ' '; Test2 = ' ';output; Name = 'XYZ'; Test1 = ' '; Test2 = 'P';output; run; Data want; Set have; WHERE Test1 NE ' ' and Test2 NE ' '; RUN; /* Also tried*/ Data want; Set have; WHERE (Test1 NE ' ' and Test2 NE ' '); RUN; /* Also tried*/ Data want; Set have; WHERE (Test1 NE ' ' )and (Test2 NE ' '); RUN; /* Also tried*/ PROC SQL; Create table want as select * from have where WHERE Test1 NE ' ' and Test2 NE ' '; QUIT; But strangely "OR" seems to be working. I am not sure what I am doing wrong here. Please can some one point me to the right direction?   /* Working*/ Data want; Set have; WHERE (Test1 NE ' ' or Test2 NE ' '); RUN; ... View more