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.
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;
Thanks Rahul. It worked perfectly.
Cheers
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.