Greetings!
I have a dilemma with time that i have been trying to figure out. I have 2 reports that use the HH:MM:SS 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.
An example:
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.
DC
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,
Dave
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.