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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.