Drop Observations with the Leading Spaces

[altijani]

Greetings Community

I have a column in my dataset that has multiple leading spaces. In case that the observation has THREE leading spaces, I want to drop that observation. Otherwise, keep. Here is what I have:

ID	Address
1	1650 OCEAN PKWY
2	1651 SEA PKWY
3	1652 RIVER PKWY

Here is what I need:

ID	Address
1	1650 OCEAN PKWY
3	1652 RIVER PKWY

Thank you.

[novinosrin]

data have;
infile cards ;
input ID +2	Address $char30.;
cards;
1  	1650 OCEAN PKWY
2	   1651 SEA PKWY
3	 1652 RIVER PKWY
;


data want;
set have;
if  substr(address,1,3)='  ' then delete;
run;

[ballardw · Accepted solution]

Or

data want;
set have;
if  address=:'  ' then delete;
run;

The =: is a "begins with"