I have the below data set that I would to remove certain variables from. Any of the variables where an observation equals 'X" I would like dropped.
I would like to know how I can code my program to remove these observations.
Okay, first let's make sure we are understanding each other properly. It seems to me that you want to drop the observations (not variables) where vendor = 'Clarity'. Is that correct? If so, please modify the title of your message.
In a data step, you need this line:
if vendor = 'Clarity' then delete;
Okay, first let's make sure we are understanding each other properly. It seems to me that you want to drop the observations (not variables) where vendor = 'Clarity'. Is that correct? If so, please modify the title of your message.
In a data step, you need this line:
if vendor = 'Clarity' then delete;
Hi @aperansi Kindly mark the solution as answered and close the thread plz. Just a request
Thank you and no apologies required. We just need to get used to it and I have the problem 🙂 Thanks again!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.