DATA Step, Macro, Functions and more

Deleting observations of a character variables using conditions

Reply
New Contributor
Posts: 4

Deleting observations of a character variables using conditions

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.

Super Contributor
Posts: 266

Re: Deleting observations of a character variables using conditions

 

 

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;

 

New Contributor
Posts: 4

Re: Deleting observations of a character variables using conditions

Thanks Rahul. It worked perfectly.

 

Cheers

Ask a Question
Discussion stats
  • 2 replies
  • 60 views
  • 0 likes
  • 2 in conversation