Sample 24591: Convert a character variable that represents a date into a SASĀ® date
The sample code on the Full Code tab illustrates how to use the INPUT function to convert a character value that represents a date into a SAS date value.
See Sample 24590: Convert variable values from character to numeric or from numeric to character for more details and examples.
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
data one;
input chardate1 :$6. chardate2 :$9. chardate3 $10. chardate4 :$9.;
datalines;
010199 31dec1999 21/09/2005 5/9/2005
;
/* Use the INPUT function to convert a character value that represents a date */
/* into a SAS date value. Choose the second parameter to the INPUT function */
/* based upon what the current character value looks like. Use a FORMAT */
/* statement to apply the date format you want when you are done. */
/* */
data two;
set one;
sasdate1=input(chardate1,mmddyy6.);
sasdate2=input(chardate2,date9.);
sasdate3=input(chardate3,ddmmyy10.);
sasdate4=input(chardate4,ddmmyy10.);
format sasdate1 mmddyy10. sasdate2 yymmdd10. sasdate3 date9. sasdate4 monyy7. ;
run;
proc print;
run;
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
Obs chardate1 chardate2 chardate3 chardate4 sasdate1 sasdate2 sasdate3 sasdate4
1 010199 31dec1999 21/09/2005 5/9/2005 01/01/1999 1999-12-31 21SEP2005 SEP2005
Use the INPUT function to convert a character value that represents a date into a SAS date value.
Type: | Sample |
Topic: | SAS Reference ==> Functions ==> Special SAS Reference ==> DATA Step
|
Date Modified: | 2007-01-13 03:03:23 |
Date Created: | 2004-09-30 14:08:56 |
Operating System and Release Information
SAS System | Base SAS | All | n/a | n/a |