topic Re: Drop Observations with the Leading Spaces in SAS Procedures

Drop Observations with the Leading Spaces

altijani — Fri, 03 May 2019 16:42:21 GMT

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.

Re: Drop Observations with the Leading Spaces

novinosrin — Fri, 03 May 2019 16:52:02 GMT

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;

Re: Drop Observations with the Leading Spaces

ballardw — Fri, 03 May 2019 17:55:20 GMT

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

The =: is a "begins with"