84.SAS QUESTION | ANSWER 01

                                         SAS  QUESTION | ANSWER  01 


QUESTION:WRITE 08JAN1992 IN THE PLACE OF MISSING VALUE..

DATA DATE;

 INFILE CARDS DLM="," MISSOVER;

 INPUT NAME$ DOB:DDMMYY10.;

 FORMAT DOB DATE9.;

 CARDS;

 Ravalika,02/12/1999

 Vamika,05/09/1996

 Prajwal, 

 Arunoday,15/08/2001

 ;

RUN;

PROC PRINT;RUN;


SOLUTION:

DATA DATE1;

 SET WORK.DATE;

 IF DOB=. THEN DOB="08JAN1992"D;

RUN;

PROC PRINT;RUN;


QUESTION:HERE ONE MORE NAME ADDED TRY TO SOLVE IT BY PLACING  09FEB2006..

DATA DATE;

 INFILE CARDS DLM="," MISSOVER;

 INPUT NAME$ DOB$20.;

 CARDS;

 Ravalika,02/12/1999

 Vamika,05/09/1996

 Prajwal, 

 Arunoday,15/08/2001

 Somnath,2006

 ;

RUN;

PROC PRINT;RUN;


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


Comments

Popular posts from this blog

409.Can We Build a Reliable Emergency Services Analytics & Fraud Detection System in SAS While Identifying and Fixing Intentional Errors?

397.If a satellite has excellent signal strength but very high latency, can it still deliver good quality communication? Why or why not?A Sas Study

401.How Efficient Are Global Data Centers? A Complete SAS Analytics Study