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!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.