116.DATA STEP | INPUT | IF THEN ELSE | PROC SQL | SELECT | CASE STATEMENTS

DATA STEP | INPUT | IF THEN ELSE | PROC SQL | SELECT | CASE STATEMENTS

 DATA work.marks;

    INPUT ID $ Name $ Subject $ Marks;

    DATALINES;

101 John Math 85

101 John Science 78

102 Alice Math 92

102 Alice Science 88

103 Bob Math 60

103 Bob Science 55

104 David Math 75

104 David Science 80

105 Emma Math 95

105 Emma Science 89

;

RUN;

PROC PRINT DATA=work.marks; 

RUN;

OUTPUT:

Obs	ID	Name	Subject	Marks
1	101	John	Math	85
2	101	John	Science	78
3	102	Alice	Math	92
4	102	Alice	Science	88
5	103	Bob	Math	60
6	103	Bob	Science	55
7	104	David	Math	75
8	104	David	Science	80
9	105	Emma	Math	95
10	105	Emma	Science	89

DATA MATH 

     SCIENCE;

 SET WORK.MARKS;

 IF SUBJECT="Math" THEN OUTPUT MATH;

 ELSE OUTPUT SCIENCE;

RUN;

PROC PRINT DATA=MATH;RUN;

PROC PRINT DATA=SCIENCE;RUN;

OUTPUT:

Obs	ID	Name	Subject	Marks
1	101	John	Math	85
2	102	Alice	Math	92
3	103	Bob	Math	60
4	104	David	Math	75
5	105	Emma	Math	95

Obs	ID	Name	Subject	Marks
1	101	John	Science	78
2	102	Alice	Science	88
3	103	Bob	Science	55
4	104	David	Science	80
5	105	Emma	Science	89

PROC SQL;

    SELECT ID, Name, Marks,

           CASE

               WHEN Marks >= 90 THEN 'A'

               WHEN Marks >= 75 THEN 'B'

               ELSE 'C'

           END AS Grade

    FROM work.marks;

QUIT;

OUTPUT:

ID	Name	Marks	Grade
101	John	85	B
101	John	78	B
102	Alice	92	A
102	Alice	88	B
103	Bob	60	C
103	Bob	55	C
104	David	75	B
104	David	80	B
105	Emma	95	A
105	Emma	89	B

COMMENT AND SHARE YOUR SYNTAX...

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