Hello,
My enterprise edition is 4.3. and I'm preparing data for geocoding addresses in ArcGIS. I am trying to remove the rows where column, Street_line1, has a blank entry. I am new to SAS Enterprise so I'm not sure if the drop function is appropriate here and using delete function makes me nervous about screwing up the database. I'd also like a count of the removed records so I can make note of them in the map.
Thanks for any help and suggestions!
If you use the Query Builder on your source dataset, default behaviour is to create a new SAS dataset, with your transformed data. Adding a filter for "Street_line1 is not null" should do it. To get a count, one way is to create a SAS program like the following:
proc sql noprint;
select count(*) into :RecCount from have where Street_line1 is null;
quit;
which will put the count into macro variable &RecCount.
Tom
If you use the Query Builder on your source dataset, default behaviour is to create a new SAS dataset, with your transformed data. Adding a filter for "Street_line1 is not null" should do it. To get a count, one way is to create a SAS program like the following:
proc sql noprint;
select count(*) into :RecCount from have where Street_line1 is null;
quit;
which will put the count into macro variable &RecCount.
Tom
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.