topic Re: Deleting observations of a character variables using conditions in SAS Programming

Deleting observations of a character variables using conditions

strqimr — Tue, 05 Sep 2017 05:27:50 GMT

Hi,

I have a data file containing a character variable named "participant_id". I designed the id to indicate the source of data like id starting with 100... is from source A, 200... from source B etc. Now I want a delete the observations of a certain source. How can I do this?

Thanks in advanced.

Re: Deleting observations of a character variables using conditions

RahulG — Tue, 05 Sep 2017 05:48:45 GMT

Code to delete data from source A. Are you looking for this ?

data want;
set have;
if substr(participant_id,1,3) ="100" then delete;
run;

Re: Deleting observations of a character variables using conditions

strqimr — Tue, 05 Sep 2017 06:00:40 GMT

Thanks Rahul. It worked perfectly.

Cheers