|Date: ||Thu, 12 Mar 1998 23:37:21 -0500|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Aaron Dukes <bsd01@SPRYNET.COM>|
|Organization: ||Breakthru Systems Development, Inc.|
|Subject: ||Re: mainframe SAS to Excel?|
|Content-Type: ||text/plain; charset=us-ascii|
your csv approach neglects the possibility that the cells themselves may
contain commas, which would really mess up your vertical column integrity.
A safer approach would be to modify FORMCHAR to make all the vertical
separators equal to the hexadecimal character combination which when
downloaded from EBCDIC to ASCII will be converted into the ASCII tab character
'09'x. (or use that character as a delimiter between vars in your put
statement, if you don't like TABULATE).
Then just have EXCEL read it as a tab-delimited text file.
| Aaron L. Dukes
| Consultant Statistician and SAS Developer
| Breakthru Systems Development, Inc.