89.CREATING DATASET | IF THEN DELETE

DATA TEMP;

INPUT ID NAME $ SALARY DEPARTMENT $14.;

LABEL ID = 'Employee ID';

DATALINES;

1 Rick 623.3 IT

2 Dan 515.2 Operations

3 Michelle 611 IT

4 Ryan 729 HR

5 Gary 843.25 Finance

6 Nina 578 IT

7 Simon 632.8 Operations

8 Guru 722.5 Finance

9 Rajiv 920 HR

10 Sarika 740 HR

;

RUN;

PROC PRINT;RUN;

OUTPUT:

The SAS System

Obs	ID	NAME	SALARY	DEPARTMENT
1	1	Rick	623.30	IT
2	2	Dan	515.20	Operations
3	3	Michelle	611.00	IT
4	4	Ryan	729.00	HR
5	5	Gary	843.25	Finance
6	6	Nina	578.00	IT
7	7	Simon	632.80	Operations
8	8	Guru	722.50	Finance
9	9	Rajiv	920.00	HR
10	10	Sarika	740.00	HR

DATA TEMP;

SET TEMP;

IF DEPARTMENT="IT" THEN DELETE;

RUN;

PROC PRINT;RUN;

OUTPUT:

The SAS System

Obs	ID	NAME	SALARY	DEPARTMENT
1	2	Dan	515.20	Operations
2	4	Ryan	729.00	HR
3	5	Gary	843.25	Finance
4	7	Simon	632.80	Operations
5	8	Guru	722.50	Finance
6	9	Rajiv	920.00	HR
7	10	Sarika	740.00	HR

TO LEARN IF STATEMENT CLICK HERE AND JUST PRACTICE....

TRY THIS AND COMMENT YOUR ANSWER...

-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES

Sas All