11-28-2014 11:59 AM
I have a dilemma with time that i have been trying to figure out. I have 2 reports that use the HH:MMS format within the project. If i copy and paste the data out of SAS directly and into the spreadsheet, it comes out exactly right.
Because i do like 30 reports every morning... i have alot of automation setup. I have SAS reports that drop to a file and then program excel to pull from the exports and insert into the column i need it put into.
Login Hours: 104:52:32 in SAS.... but when it drops to excel via an export process, it is 8:85:32. I use Timew9. as the format in SAS and Time 37:30:55 in excel.
How can I make the export match what SAS is showing in the dataset? Any guidance would be appreciated.
11-30-2014 07:34 PM
This is really an Excel issue rather a SAS or EG issue.
If you look the formatting of an example where you have pasted the SAS time 104:52:32 into Excel (right click Format Cells... > Number) you notice that it is a Custom format
Hope this helps,