Help with datepart

#1
Hi, Please help me with this..

I have a column in my data TYPE: Number FORMAT: datetime20.

Im using using proc sql and need to remove the timestamp and just have the dates.

instead of 01jan2015:00:03:21 I need 01jan2015.

this is my current query - it runs but doesnt change the table.

proc sql;
create table test1.tableme as
select A.*,
datepart(A.Address_TIME)format date9.
from
romand.tableyou A

I tried ^ and withtout the date 9, but nothing seems to work.. HELP :)
 
#2
Try this:
Code:
proc	sql;
	create table test1.tableme
	as select A.*, put(datepart(A.Address_TIME), date9.) as AddressDate
	from romand.tableyou A;
quit;
Which version of SAS are you using?