How to convert a given date value into SAS date
Answer Posted / arish kumar
e.g the date is '05/09/2007'
we can use the input function to convert this string into SAS date i.e.
date='05/09/2007'
sasdate=input(date,mmddyy10.);
Also, we can use mdy function.For this first use substr function.
m=substr(date,4,2);
d=substr(date,1,2);
y=substr(date,7,4);
sasdate=mdy(m,d,y);
| Is This Answer Correct ? | 21 Yes | 3 No |
Post New Answer View All Answers
How would you define the end of a macro? : sas-macro
Explain how merging helps to combine data sets.
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
what is the difference between nodup and nodupkey options? : Sas programming
what are the component of range? : Sas-bi
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
what are some good sas programming practices for processing very large data sets? : Sas programming
What is the difference between order and group variable in proc report?
Difference between sum function and using “+” operator?
what are some differences between proc summary and proc means? : Sas programming
how do the in= variables improve the capability of a merge? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specifications?
Describe a time when you were really stuck on a problem and how you solved it?
Differentiate input and infile.
What are the features of base sas system?