Usage Note 24527: How can I convert a character date variable to a numeric date variable with PROC SQL?
The INPUT function can be used within PROC SQL to create a numeric date variable from a character date string.
data chardate;
date='08/30/2006';
run;
proc sql;
create table new as select INPUT(date,mmddyy10.)
as newdate format=mmddyy10.
from chardate;
quit;
Operating System and Release Information
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | low |
| Topic: | SAS Reference ==> SQL
|
| Date Modified: | 2008-02-19 14:33:52 |
| Date Created: | 2006-08-30 16:39:34 |
