Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert a given date value into SAS date
- 9 Answers
- 39116 Views
- CitiGroup, Quintiles, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ranjith
we can store date values using date format
(ex:date9.,ddmmyyyy10.)
| Is This Answer Correct ? | 32 Yes | 3 No |
Answer / 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 |
Answer / vipin choudhary
We can read the date value with the help of date informats.
Say we have the date 09/13/2008.
Now if we want SAS to read this date, we will use the date
informat in the input statement like
"input date mmddyy10."
SAS will store this date in the numerical form as the
number of days passed from 1st january, 1960.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / geoffrey brent
If you don't know in advance how the date will be
formatted, you can use the ANYDTDTE. informat. This will
extract a SAS date from most date/date-time formats.
(Warning: ANYDTDTE doesn't fully support day-month-year
ordering, even if you have this set as your system
preference, but it still copes with most DMY-formatted
dates.)
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / komal
For example if we have a date="14/12/2008".
you have to input it first and the format it like
date1=input(date,ddmmyy10.);
format date1 ddmmyy10.;
run;
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / srinivas krishnan
in sas :: we can store like this `12-07-2009`d
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / vinay
/*let date is '10/07/1985'/*
/*SAS CODING*/
data date;
input date $;
Var_Date=input(date,mmddyy10.);/*Apply format within input
function to convert text value to number value*/
/*now extract value of month,date and year through date
functions*/
m=substr(Var_Date,4,2);
d=substr(Var_Date,1,2);
y=substr(Var_Date,7,4);
sasdate=mdy(m,d,y);
cards;
10/07/1985
;
run;
proc print dtat=date;
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Actually sas stores dates as numbers
eg:: given date 12-07-2009
in sas :: we can store like this `12-07-2009`d
| Is This Answer Correct ? | 10 Yes | 16 No |
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
What is a put statement?
Explain the main difference between the sas procedures and functions? : Sas-administrator
What are the table names in oracle database...?
What does a PROC TRANSPOSE do?
hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process
define table lookup and how may ways it can be done...explian
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Can anyone help me about SAS Realtime scenarios in Clinical field
How to limit decimal places for the variable using proc means?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
When merging 2 datasets with a common variable (not merge key), how to keep both?
Teradata 
