topic Re: Dropping Variables based on conditions in New SAS User

Dropping observations based on conditions

aperansi — Thu, 08 Nov 2018 19:52:43 GMT

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.

Re: Dropping Variables based on conditions

PaigeMiller — Thu, 08 Nov 2018 19:40:10 GMT

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;

Re: Dropping Variables based on conditions

aperansi — Thu, 08 Nov 2018 19:41:58 GMT

You are correct in your assumption, and my apologies for the confusion. I meant I wanted to drop the observations in which vendor equaled clarity. Thank you very much for providing me with the solution.

Re: Dropping Variables based on conditions

novinosrin — Thu, 08 Nov 2018 19:48:08 GMT

Hi @aperansi Kindly mark the solution as answered and close the thread plz. Just a request

Re: Dropping Variables based on conditions

aperansi — Thu, 08 Nov 2018 20:05:33 GMT

My apologies. I accepted it as a solution.

Re: Dropping Variables based on conditions

novinosrin — Thu, 08 Nov 2018 20:35:57 GMT

Thank you and no apologies required. We just need to get used to it and I have the problem 🙂 Thanks again!