Convert date to text date sas

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.

Also, for more information about date functions, see the following SAS tutorial video:

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.

Operating System and Release Information