PROC SQL;
CREATE TABLE address_blanks AS
SELECT *
FROM vixen.address_data
WHERE adr_attention EQ ' ' AND
adr_flat EQ ' ' AND
adr_house_no EQ ' ' AND
adr_primary_ln EQ ' ' AND
adr_secondary_ln EQ ' ' AND
adr_district EQ ' ' AND
adr_city EQ ' ' AND
adr_county_name EQ ' ' AND
adr_post_code EQ ' ';
QUIT;

Click to expand...