08-27-2015 01:37 AM
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
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
08-27-2015 08:05 AM
ne stands for not equal to:
input Employee_id$ Dept$;
where dept ne 'Sales';
08-27-2015 08:16 AM
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: