118.INPUT | ASSIGNMENT | PROC SORT STATEMENTS

DATA EMPLOYEE_DETAILS;

INPUT ID Name $ Department $ Salary;

DATALINES;

1 John Sales 50000

2 Jane Marketing 55000

3 Jim IT 60000

4 Jill HR 52000

5 Jack Finance 58000

6 Judy Operations 62000

7 Joe Legal 54000

8 Jenny R&D 61000

9 Jeff Support 53000

10 Julia Administration 57000

;

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	ID	Name	Department	Salary
1	1	John	Sales	50000
2	2	Jane	Marketin	55000
3	3	Jim	IT	60000
4	4	Jill	HR	52000
5	5	Jack	Finance	58000
6	6	Judy	Operatio	62000
7	7	Joe	Legal	54000
8	8	Jenny	R&D	61000
9	9	Jeff	Support	53000
10	10	Julia	Administ	57000

DATA EMPLOYEE_DETAILS;

SET EMPLOYEE_DETAILS;

BONUS = SALARY * 0.25;

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	ID	Name	Department	Salary	BONUS
1	1	John	Sales	50000	12500
2	2	Jane	Marketin	55000	13750
3	3	Jim	IT	60000	15000
4	4	Jill	HR	52000	13000
5	5	Jack	Finance	58000	14500
6	6	Judy	Operatio	62000	15500
7	7	Joe	Legal	54000	13500
8	8	Jenny	R&D	61000	15250
9	9	Jeff	Support	53000	13250
10	10	Julia	Administ	57000	14250

PROC SORT DATA=EMPLOYEE_DETAILS OUT=EMPLOYEE_DETAILS01;

BY SALARY;

RUN;

PROC PRINT;RUN;

OUTPUT:

Obs	ID	Name	Department	Salary	BONUS
1	1	John	Sales	50000	12500
2	4	Jill	HR	52000	13000
3	9	Jeff	Support	53000	13250
4	7	Joe	Legal	54000	13500
5	2	Jane	Marketin	55000	13750
6	10	Julia	Administ	57000	14250
7	5	Jack	Finance	58000	14500
8	3	Jim	IT	60000	15000
9	8	Jenny	R&D	61000	15250
10	6	Judy	Operatio	62000	15500

ADD SOME MORE STATEMENTS LIKE FORMAT , LABEL , TITLE ETC AND COMMENT YOUR CODE...

-->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