create new date in proc sql

[bhca60]

How would I create a new date - i've tried a put statement, input to format it but nothing works:

proc sql;
create table example
as select
id,
(edate, yymmdd10.) as edate2
from table
quit;

ERROR 22-322: Syntax error, expecting one of the following: (, ).  

ERROR 76-322: Syntax error, statement will be ignored.

30       ! (edate, yymmdd10.) as edate2
                                _
                                22
ERROR 22-322: Syntax error, expecting one of the following: a name, *.  

[andreas_lds]

Do you know how sas handles dates?

Please post some information about the variable edate: type, length?

[bhca60]

CHAR $10.

[Kurt_Bremser]

If edate is a character variable containing date strings, do the conversion to a SAS date like this:

input(edate, yymmdd10.) format=yymmdd10. as edate2