24591 - Convert a character variable that represents a date into a SAS® date

Sample 24591: Convert a character variable that represents a date into a SAS® date

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

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

Product Family	Product	Host	SAS Release
			Starting	Ending
SAS System	Base SAS	All	n/a	n/a

Support

Sample 24591: Convert a character variable that represents a date into a SAS® date

Operating System and Release Information