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
Post a Comment