09-05-2017 01:27 AM
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.
09-05-2017 01:48 AM
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;