03-24-2014 10:15 AM
When we were using SAS 9.3 I could simply select all the below fields, copy them using CTRL-C, and paste them directly into Excel. Now, using SAS 9.4, the two left-hand columns cannot be copied, because they are formatted. Only plain values, such as in the right-hand column, can be copied. If I select all three column and hit CTRL-C, nothing is copied.
The only semi-practical workaround I've found, is to set up an extract where I convert all formatted numerics into characters, which enables me to copy them. However this can be very tedious when there's many numeric columns; especially when there's many dates which must be converted.
Extracting the work table to a CSV-file isn't an option, because these data extractions must be made from our production environment, where I don't have authorization to access PIPE.
Is there any setting I (or an administrator) can adjust in order to enable us to copy formatted numeric values from DI Studio to Excel, like we could in SAS 9.3?
03-24-2014 02:21 PM
I'm just in the process of upgrading, so I haven't tested myself.
But I wonder about this issue. Annoying I believe. But I don't understand why this could be an issue in a production environment. Running jobs interactively and browse partial results seems more like typical development/test situation.
There are other tool that may be more useful for ad-hoc queries and data analysis (and Excel-reporting), such Enterprise Guide.
03-24-2014 05:10 PM
True I typically use EG to handle such queries, but once in a while I get a request which can be handled more efficiently by copying a DI Studio job to 'my folder', making some slight adjustments to it there, then copy/pasting the output directly into a spreadsheet. At least that used to be the case, before we migrated to SAS 9.4 and this problem started occurring.
03-25-2014 04:43 AM
Either way, you may want to report this to SAS tech support.
What is effective depends on the user, I often use EG, open the deployed SAS code, make my adjustments and execute it.
But I'm glad to hear that there are users/developers who like working in DIS, unfortunately it's often the opposite...