USER_ID |
|
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
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.