topic Re: Alternative of EXCEPT operator in Data Step in SAS Procedures

Alternative of EXCEPT operator in Data Step

samirt — Thu, 27 Aug 2015 05:37:26 GMT

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

Re: Alternative of EXCEPT operator in Data Step

Steelers_In_DC — Thu, 27 Aug 2015 12:05:44 GMT

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;

Re: Alternative of EXCEPT operator in Data Step

RW9 — Thu, 27 Aug 2015 12:16:50 GMT

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:

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Base SAS(R) 9.2 Procedures Guide

Re: Alternative of EXCEPT operator in Data Step

samirt — Thu, 27 Aug 2015 12:23:59 GMT

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