Hello everyone,
I am having a table name employee_organization which consist of all employee name of the organization and employee_sales employee name of sales department
Employee_id Dept
1453253 Accounts
7866341 Sales
2333642 HR
4566333 Accounts
2223355 Operation
Employee_id Dept
7866341 Sales
I want to get the output of all employees which are not from Sales department. It is possible by using PROC SQL SAS Except operator.
I would like to know how it is possible to achieve aforementioned task using DATA Step
Thanks in advance
ne stands for not equal to:
data have;
infile cards;
input Employee_id$ Dept$;
cards;
1453253 Accounts
7866341 Sales
2333642 HR
4566333 Accounts
2223355 Operation
;
data want;
set have;
where dept ne 'Sales';
run;
Thanks for the reply
Actually as EXCEPT operator perform vertically on the table. I was in dilemma is there any way of using SET statement in data step
You can achieve this in any language in a variety of ways.
data step - where clause, if then clause
sql - where clause
This is basic SAS operation, and can be found here:
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!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.