Proc Export Excel retaining datetime format

Q1983 — Tue, 13 Dec 2016 17:14:32 GMT

USER_ID	EMAIL	LAST_LOGIN	USER_TYPE	SECURITY_GROUP	IS_ACTIVE	ACCOUNT_LOCKED	ACCOUNT_INACTIVE
xxxx	john.B.Iwoa@me.com	13Dec2016 12:01:00.000	1	LOS	Y	N	N
eeee	john.B.Iwoa@me.com	13Dec2016 11:02:00.000	1	LOS	Y	N	N

proc export data=Los_Prod_Logins

outfile="\\Corp\DFS\Mortgage_Shared\VA019\F01B\Everyone\MBIO_ADHOC_SHARED\Emp_Los_Prod\Dly_Loss_Prod_Login_&rptdate.xlsb"

dbms=ExcelCS replace;

server='GA016A744';

it exports to a shared drive as Dly_Loss_Prod_Login_20161213 where &rptdate reporesents the date

However when I export, I loose the datetime format which is needed for this particular report. I tried xls, xlsx, and xlsb format

Would I have to go with an ODS output delivery or is there a way to export directly to a share drive, keeping the datetime format. In this case LAST_LOGIN

Re: Proc Export Excel retaining datetime format

Shmuel — Tue, 13 Dec 2016 17:49:39 GMT

Use ODS excel tagattr to assign excel format to the exported variable.

See pages 3-4 on:

http://support.sas.com/resources/papers/proceedings10/031-2010.pdf

topic Re: Proc Export Excel retaining datetime format in SAS Programming

Proc Export Excel retaining datetime format

Re: Proc Export Excel retaining datetime format