87.MISSING DATA | INPUT STATEMENT | IF THEN DO STATEMENT

           MISSING DATA | INPUT STATEMENT | IF THEN DO STATEMENT

DATA MISSING_DATA;

 INPUT NAME : $15. AGE : $3. DEPARTMENT : $30. SALARY : $5.;

 CARDS;

 SAISRI 16 PHYSICS 10000

 SMITHARAI 20 CHEMISTRY 20000

 MAAYA 23 . 30000

 RAZIA . MATHEMATICS 40000

 KUSHALSINGH 25 GEOGRAPHY 50000

 RAMSINGH 26 . 75000

 HARISHROY . . 60000

 ;

RUN;

PROC PRINT;RUN;

OUTPUT:

The SAS System

Obs	NAME	AGE	DEPARTMENT	SALARY
1	SAISRI	16	PHYSICS	10000
2	SMITHARAI	20	CHEMISTRY	20000
3	MAAYA	23		30000
4	RAZIA		MATHEMATICS	40000
5	KUSHALSINGH	25	GEOGRAPHY	50000
6	RAMSINGH	26		75000
7	HARISHROY			60000

DATA INPUT(DROP=AGE);

 SET MISSING_DATA;

 AGEE=INPUT(AGE,3.);

RUN;

PROC PRINT;

RUN;

OUTPUT:

The SAS System Obs NAME DEPARTMENT SALARY AGEE 1 SAISRI PHYSICS 10000 16 2 SMITHARAI CHEMISTRY 20000 20 3 MAAYA   30000 23 4 RAZIA MATHEMATICS 40000 . 5 KUSHALSINGH GEOGRAPHY 50000 25 6 RAMSINGH   75000 26 7 HARISHROY   60000 .

DATA INPUT;

 SET INPUT(RENAME=(AGEE=AGE) RENAME=(DEPARTMENT=SUBJECT));

 IF NAME="MAAYA" THEN DO;

     SUBJECT="BIOLOGY";

 END;

 IF NAME="RAZIA" THEN DO;

     AGE=26;

 END;

 IF NAME="RAMSINGH" THEN DO;

      SUBJECT="HISTORY";

 END;

 IF NAME="HARISHROY" THEN DO;

      AGE=23;

      SUBJECT="SANSKRIT";

 END;

RUN;

PROC PRINT;RUN;

OUTPUT:

The SAS System

Obs	NAME	SUBJECT	SALARY	AGE
1	SAISRI	PHYSICS	10000	16
2	SMITHARAI	CHEMISTRY	20000	20
3	MAAYA	BIOLOGY	30000	23
4	RAZIA	MATHEMATICS	40000	26
5	KUSHALSINGH	GEOGRAPHY	50000	25
6	RAMSINGH	HISTORY	75000	26
7	HARISHROY	SANSKRIT	60000	23

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