BookmarkSubscribeRSS Feed
maggi2410
Obsidian | Level 7

Hi,

Proc export is truncating the length of columns for more then 256 characters.Now I found this note on SAS website:

http://support.sas.com/kb/34/119.html

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....


1 REPLY 1
Damien_Mather
Lapis Lazuli | Level 10

Hi Maggi.

Easiest for you I think would be for you to use the PCFILES engine of the libname statement.

see

http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n12tx6b9ilne0kn198...

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.

Cheers.

Damien

sas-innovate-2024.png

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.

 

Register now!

Discussion stats
  • 1 reply
  • 3266 views
  • 0 likes
  • 2 in conversation