85.SAS QUESTION | ANSWER 02

                                   SAS QUESTION | ANSWER 02

QUESTION:CALCULATE THE AGE FOR THIS DATA..

DATA DATE;

 INFILE CARDS DLM=",";

 INPUT NAME$ DOB:DDMMYY10.;

 FORMAT DOB DATE9.;

 CARDS;

 Ravalika,02/12/1999

 Vamika,05/09/1996

 Prajwal,08/01/1992 

 Arunoday,15/08/2001

 Somnath,09/02/2006

 ;

RUN;

PROC PRINT;RUN;

OUTPUT:

 

The SAS System

Obs	NAME	DOB
1	Ravalika	02DEC1999
2	Vamika	05SEP1996
3	Prajwal	08JAN1992
4	Arunoday	15AUG2001
5	Somnath	09FEB2006

/*CALCULATE THE AGE OF ABOVE DATA AS PER TODAY*/

DATA AGE;

 SET DATE;

 AGE=INTCK('YEAR',DOB,TODAY());

RUN;

PROC PRINT;RUN;

SOLUTION:

The SAS System

Obs	NAME	DOB	AGE
1	Ravalika	02DEC1999	16
2	Vamika	05SEP1996	19
3	Prajwal	08JAN1992	23
4	Arunoday	15AUG2001	14
5	Somnath	09FEB2006	9

/*ADD ANY OTHER VARIABLES LIKE CLASS,RANK ETC AND COMMENT YOUR ANSWER*/

QUESTION 2:ADD ANY OTHER VARIABLES LIKE CLASS,RANK ETC.. 

DATA DATE;

 INFILE CARDS DLM=",";

 INPUT NAME$ DOB:DDMMYY10.;

 FORMAT DOB DATE9.;

 CARDS;

 Ravalika,02/12/1999

 Vamika,05/09/1996

 Prajwal,08/01/1992 

 Arunoday,15/08/2001

 Somnath,09/02/2006

 ;

RUN;

PROC PRINT;RUN;

YESTERDAY'S SOLUTION:

DATA DATE;

 SET DATE;

 IF DOB='' THEN DOB='08/01/1992';

 ELSE IF DOB='2006' THEN DOB='01/02/2006';

RUN;

PROC PRINT;RUN;

OUTPUT:

The SAS System

Obs	NAME	DOB
1	Ravalika	02/12/1999
2	Vamika	05/09/1996
3	Prajwal	08/01/1992
4	Arunoday	15/08/2001
5	Somnath	01/02/2006

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