88.CREATING MULTIPLE DATASETS | IF THEN OUTPUT STATEMENT

        CREATING MULTIPLE DATASETS | IF THEN OUTPUT STATEMENT

  

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 IT HR FINANCE OPERATION;

 SET TEMP;

 IF DEPARTMENT="IT" THEN OUTPUT IT;

 ELSE IF DEPARTMENT="HR" THEN OUTPUT HR;

 ELSE IF DEPARTMENT="Finance" THEN OUTPUT FINANCE;

 ELSE IF DEPARTMENT="Operations" THEN OUTPUT OPERATION;

 FORMAT SALARY DOLLAR12.;

RUN;

PROC PRINT DATA=WORK.IT;

RUN;

OUTPUT:

The SAS System

Obs	ID	NAME	SALARY	DEPARTMENT
1	1	Rick	$623	IT
2	3	Michelle	$611	IT
3	6	Nina	$578	IT

PROC PRINT DATA=WORK.HR;

RUN;

OUTPUT:

   

The SAS System

Obs	ID	NAME	SALARY	DEPARTMENT
1	4	Ryan	$729	HR
2	9	Rajiv	$920	HR
3	10	Sarika	$740	HR

PROC PRINT DATA=WORK.FINANCE;

RUN;

OUTPUT:

The SAS System

Obs	ID	NAME	SALARY	DEPARTMENT
1	5	Gary	$843	Finance
2	8	Guru	$723	Finance

PROC PRINT DATA=WORK.OPERATION;

RUN;

The SAS System

Obs	ID	NAME	SALARY	DEPARTMENT
1	2	Dan	$515	Operations
2	7	Simon	$633	Operations

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

   CLICK HERE: https://t.me/SasAll4You