topic create new date in proc sql in SAS Enterprise Guide

create new date in proc sql

bhca60 — Tue, 12 Jul 2022 05:01:21 GMT

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, *.

Re: create new date in proc sql

andreas_lds — Tue, 12 Jul 2022 05:40:26 GMT

Do you know how sas handles dates?

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

Re: create new date in proc sql

bhca60 — Tue, 12 Jul 2022 05:44:04 GMT

CHAR $10.

Re: create new date in proc sql

Kurt_Bremser — Tue, 12 Jul 2022 05:51:51 GMT

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