11-30-2012 06:49 PM
Proc export is truncating the length of columns for more then 256 characters.Now I found this note on SAS website:
Itsays:To circumvent the problem, export the file as a tab-delimited text file and import that text file into Excel.
I understand exporting the file to tab delimited text file. But then how would I automatically convert this tab delimted file to excel?
Any ideas?Mine is UNIX system, and I cannot use SAS libname statement.
I can use ods html to create excel, but ui have values like 0.80,0.90 and ods is converting them to 0.8 and 0.9 respectively....
11-30-2012 08:01 PM
Easiest for you I think would be for you to use the PCFILES engine of the libname statement.
Let me know if this helps.
PS I miss my SAS/UNIX combination sometimes - SAS filename statement with the pipe option pointing to an underlying unix pipe was something I found very helpful.