|
USER_ID
|
EMAIL
|
LAST_LOGIN
|
USER_TYPE
|
SECURITY_GROUP
|
IS_ACTIVE
|
ACCOUNT_LOCKED
|
ACCOUNT_INACTIVE
|
|
xxxx
|
[email protected]
|
13Dec2016 12:01:00.000
|
1
|
LOS
|
Y
|
N
|
N
|
|
|
eeee
|
[email protected]
|
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
