topic Cleaning database from invalid entries in SAS Programming

Cleaning database from invalid entries

JibJam221 — Thu, 19 May 2022 13:56:56 GMT

Hi all,

im trying to create a code that can clean my database. Basically, I am trying to clean the database from invalid record entries (i.e. therefore removing records containing responses using special characters such as $, #, % and pasting them into a separate SAS table).

The column name with special containing responses needing cleaning is "ID_Response".

I dont have a code to share because im not sure where to start. Any recommendations?

Re: Cleaning database from invalid entries

Kurt_Bremser — Thu, 19 May 2022 14:06:35 GMT

To find a certain character in a string, use the INDEXC Function.

Re: Cleaning database from invalid entries

JibJam221 — Thu, 19 May 2022 14:18:23 GMT

thank you! Do you know how I can extract these records into a separate SAS dataset?

Re: Cleaning database from invalid entries

Kurt_Bremser — Thu, 19 May 2022 15:46:01 GMT

data extract;
set have;
where indexc(id_response,'#') or indexc(id_response,'$') or indexc(id_response,'%');
run;