Hi Everyone, I have this problem that looks sooooo simple but can't seem to figure it out, as it gives no errors. I have this variable called 'specialty'. It consists of numeric values. I want to extract only the code 1 and 95 from my data set. I used the code below: data specialty_code;
set master_data;
where specialty=1 and 95;
run; When I submit it, it runs smoothly and gives me the observation number of x. but when I do a quick quality check, it only kept the specialty code 1 and didn't keep any of the code 95. Am I using the where statement wrong? It worked when I used where-and statement for 2 different variables. Thanks!!
... View more