BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ilikesas
Barite | Level 11

hi,

suppose I have the following table:

sectorcompany
Aaa
Bbb
Ccc
Ddd

I want to set the table but drop all the entries where the sector is either A or B and get the following:

sectorcompany
Ccc
Ddd

It is probably a simple task but when I run the following code I still can't get the answer:

data table;

set table;

if sector ne  "A" or sector ne  "B" ;

run;

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Ksharp
Super User

If I was right.

if sector ne  "A" and sector ne  "B" ;



if sector  not in  ('A' 'B')  ;



View solution in original post

1 REPLY 1
Ksharp
Super User

If I was right.

if sector ne  "A" and sector ne  "B" ;



if sector  not in  ('A' 'B')  ;



sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 683 views
  • 0 likes
  • 2 in conversation