How to convert a given date value into SAS date

Answer Posted / sheetal

data temp;
date='17/12/2009';
m=substr(date,4,2);
d=substr(date,1,2);
y=substr(date,7,4);
d1=mdy(m,d,y);
format d1 mmddyy10.;
run;

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

4912


what are the best practices to process the large data sets in sas programming? : Sas-administrator

537


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

940


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

1612


What is substr function?

626






What is the function of Stop statement in a SAS Program?

642


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

690


What are the different versions of sas that you have used until now? : sas-grid-administration

733


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1460


What would be the value of month at the end of data step execution and how many observations would be there?

576


What does PROC print, and PROC contents do?

727


where to use sas business intelligence? : Sas-bi

580


what is null hypothesis? why do you consider that?

2417


Which function is used to count the number of intervals between two sas dates?

569


Explain the use of proc print and proc contents?

557